SQL Performance (MOSC)

MOSC Banner

anyone aware of index$_join$_001

edited Nov 26, 2013 7:01PM in SQL Performance (MOSC) 6 commentsAnswered
hi,

in one of the query we found there is an object created with index$_join$_001 object which does exist in database.

It was one of the reason for slowing down the query response time? I did not find much supportive documents as to why this is created and if its created on the fly.

If any of you have further investigated on it, can you please share your understanding on this cause.

Thanks

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