From: member29273@dbforums.com   
      
   Yes, stats on indexes affects execution plans, but if you're using 9i   
   oracle make a little sample on non-analyzed objects.   
      
      
      
   Originally posted by Hrishy   
      
   > Hi All   
      
   >   
      
   > I was just wundering what happens if we dont gather stats on indexes   
      
   > will it effect the optimiser plans ?   
      
   >   
      
   > regards   
      
   Hrishy   
      
      
   --   
   Posted via http://dbforums.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)