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. 12-12-2005, 05:34 PM #11
    andreaplanet
    andreaplanet is offline Junior Member
    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;
    Reply With Quote Reply With Quote
  2. 12-12-2005, 07:26 PM #12
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    tell us buffer gets per executions and not the cumulative buffer gets
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width