SQL Performance (MOSC)

MOSC Banner

Rebuild Index is not meeting expectation

edited Feb 16, 2016 4:05AM in SQL Performance (MOSC) 8 commentsAnswered

We're facing an issue with indexes. Below are details please let me know how to handle this scenario.

1. We have tables built with UNIQUE KEY and PRIMARY KEY indexes.

2. Very first time we created tables and loaded data and the results are expected with the given SQL using index hints.

3. After batch cycle the access path is changing and results are not expected meaning not in expected order and also performance become very poor.

4. Tried all the possible REBUILD options and COLLECT STATS, but the access path is not getting back as initial.

5. When we drop table and recreate with indexes and reload then again the access path is as expected, but drop table/recreate/reload task we cannot do every day due to time consuming factor we need to avoid and need any alternative solution on this issue.

Tagged:

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