Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: I just want to join to one more table!
Hi,
How big are contactphone and contactaddress? How selective are the columns (i.e. how many unique values)? What optimizer mode are you using (rule-based, cost-based)? Do you regularly gather statistics (analyze)?
One of the most common causes of indexes not being used when it seems they should be is when there is a column datatype mismatch, causing an implicit datatype conversion function to be used by Oracle. In this case, indexes on the converted column would not be used.
If this is not the case and all else fails, you could try adding optimizer hints in the code.
HTH, Dave.
Sent via Deja.com
http://www.deja.com/
Received on Thu Dec 28 2000 - 08:24:41 CST