Re: I just want to join to one more table!

From: <jimbo1155_at_my-deja.com>
Date: Thu, 28 Dec 2000 14:39:12 GMT
Message-ID: <92fjaf$atd$1@nnrp1.deja.com>

Hi Dave,
contactphone and contactaddress have about 1m rows each. I just posted another message where I note that the column I'm joining on (siebelcontactid), which has an index on all these tables, is defined (probably incorrectly) without the not null statement in contactaddress. Otherwise the column is defined the same way on all the tables.

I'll have to get to the dba with some of the other stuff you mention. Thanks,
Jim
In article <92fif4$aa8$1_at_nnrp1.deja.com>, Luggy <dave_at_oracle-consultant.co.uk> wrote:
> 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/
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 28 2000 - 08:39:12 CST