stats on indexes

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • hrishy

    stats on indexes

    Hi All

    I was just wundering what happens if we dont gather stats on indexes
    will it effect the optimiser plans ?

    regards
    Hrishy
  • ndu35

    #2
    Re: stats on indexes


    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

    Comment

    • Mark D Powell

      #3
      Re: stats on indexes

      ndu35 <member29273@db forums.comwrote in message news:<3484958.1 066236300@dbfor ums.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
      Depending on the option used to gather statistics Oracle often
      automatically generates index statistics when you generate statistics
      on the base table.

      Example: analyze table bob.table_with_ indexes compute statistiscs [OR
      sample] will generate statistics for the table and all its indexes.

      HTH -- Mark D Powell --

      Comment

      Working...