what will be right way to deal with this query - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: what will be right way to deal with this query

  1. #11
    Join Date
    Dec 2005
    Posts
    3
    maybe a stupid suggestion but do you created well the statistics? try to use both:
    analze table x estimate statistics;
    analze table x estimate statistics for all indexes;

  2. #12
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    tell us buffer gets per executions and not the cumulative buffer gets

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width