Re: Partitioned Index & Index_stats - how-to - no-one has an idea?

From: Andras Kovacs <andkovacs_at_yahoo.com>
Date: 25 Aug 2003 05:01:01 -0700
Message-ID: <412ebb69.0308250401.758f2781@posting.google.com>

You question isn't clear.
Statistics are always important on tables and indexes. If you have several indexes on your table, Oracle has to choose an index for your query. The choice will be based on the information available. If no stats are available Oracle might choose the bad index. Received on Mon Aug 25 2003 - 07:01:01 CDT

This message: [ Message body ]
Next message: Fabrizio Napolitano: "Re: Partitioned Index & Index_stats - how-to - no-one has an idea?"
Previous message: Marc Eggenberger: "Turn tracing on for a session"
In reply to: Fabrizio Napolitano: "Re: Partitioned Index & Index_stats - how-to - no-one has an idea?"
Next in thread: Fabrizio Napolitano: "Re: Partitioned Index & Index_stats - how-to - no-one has an idea?"
Reply: Fabrizio Napolitano: "Re: Partitioned Index & Index_stats - how-to - no-one has an idea?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US