Database Tuning (MOSC)

MOSC Banner

View query not using index

edited Mar 13, 2009 4:10AM in Database Tuning (MOSC) 4 commentsAnswered
 Hi All, I have a query on a view which join another table(9i). I have proper statistics on these tables.But when I check the explain plan it shows that it is using one index and running in 8 seconds. But when I forced another index it runs in 2 seconds. Any reason?

Another point, when I gathered statistics with histograms then the oracle is not using index at and taking 30 seconds to execute. Then I gathered stats without histograms. Then at least it is using one index, not the one which was giving optimum performance though.

Please suggest ... Thank You.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center