By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,501 Members | 1,859 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,501 IT Pros & Developers. It's quick & easy.

Adding Index to Table may reduce performance of Some Select Statements ?

P: n/a
Guy’s,

Adding Index to Table may reduce performance of Some Select?

Thanks in advance,
Srini
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
sr********@yahoo.com (srinik) wrote in message news:<95**************************@posting.google. com>...
Guy’s,

Adding Index to Table may reduce performance of Some Select?

Thanks in advance,
Srini


Vague response for a vague question without any sensible clue:
'it depends'

Sybrand Bakker
Senior Oracle DBA
Jul 19 '05 #2

P: n/a
To receive any useful information, you will certainly need to provide
additional details on your setup, or find someone more familiar with
your Oracle to do it for you. The cases where I saw that an additional
index slowed some select statements was generally when:
- rule-based optimizing is used and the new index has low cardinality
columns (few distinct values)
- cost-based optimizing is used, and the stats are not kept up-to-date
- cost-based optimizing is used, and the indexed columns suffer from
skewness, and no histograms are used.

Those are 3 examples, and is certainly not a complete list.

Daniel

sr********@yahoo.com (srinik) wrote in message news:<95**************************@posting.google. com>...
Guy’s,

Adding Index to Table may reduce performance of Some Select?

Thanks in advance,
Srini

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.