Forcing an INDEX to be used in a LEFT JOIN

[LeonelSanchezJr]

I have a query which is NOT using any INDEX in one of my LEFT JOINs despite the fact that both tables have the field INDEXed.

Is there some type of Syntax that would force it to use an INDEX?

This is my JOIN syntax:

LEFT JOIN TABLE_A
ON TABLE_B.NUMBER_ID = TABLE_A.DOC_ID

Thanks,

Leo ;-)

 

[LKBrwnDBA]

You could try using an "index" hint

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[LKBrwnDBA]

PS: Optimizer to use existing indexes requires tables/indexes to be ANALYZEd.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[LeonelSanchezJr]

Oh my, you are on a roll; aren't you.

Thanks,

Leo ;-)