DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 21

Thread: index not used for negative numbers

Threaded View

  1. 07-29-2010, 12:46 AM #11
    vnktummala's Avatar
    vnktummala
    vnktummala is offline Senior Advisor
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Quote Originally Posted by mitpat121 View Post
    hi all,

    i checked dba_tab_statistics for stale stats
    but STALE_STATS column contain no and null values.
    null value for global temporary table what is it mean and
    one more thing i noticed global temporary table has never been analyzed.

    plz provide suggetions
    thx
    that is quite obvious. They are Global TEMPORARY Tables. Please google it for more information.

    Thanks,
    Last edited by vnktummala; 07-29-2010 at 12:46 AM. Reason: typo
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.
    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