stats on index
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: stats on index

  1. #1
    Join Date
    Jun 2001
    Posts
    150
    Hi
    can some one please explain me that if i add a new index on a existing table and do not analyze the table then will oracle use that index properly or not in cost based optimizer.

    The datatabase version is 7.3.4.4 .Please also tell me what will be the effect in 8i.

    Ta
    UKDBA

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    My gut tells me no, run an explain on it and prove me wrong.

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    If the table has stats on it the CBO may still pick an index that does not have stats. Even so, the CBO relies on stats to make it's judgement. You should always gather stats for all indexes and tables in your schema. If in doubt redo the stats.

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

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