ecipients of list ORACLE-L
> Subject: RE: FW: [ Danone ] - Hung Oracle Query
>
> yep, and before everyone else tries to waste time looking at this, I
> mentioned to the developer that he was using a non-indexed column (a.city
> code) in the where clause and that is why he is
yep, and before everyone else tries to waste time looking at this, I
mentioned to the developer that he was using a non-indexed column (a.city
code) in the where clause and that is why he is doing a full table scan on
one of the large tables (address). His reply, exactly, now how do I get
around t
Have you rerun the analyzer to generate new statistics? Just a thot...RBG
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, February 14, 2001 9:26 AM
> Thanks for the responses from you guys. I went back to our developer with
> your su
Thanks for the responses from you guys. I went back to our developer with
your suggestions and he said, wait for this one !!!
Oh I did select from all the tables in the query, I just chopped them out
when I passed it onto you as I didn't think it was necessary.
Original problem was ...
Since th
Why do you even have the tables consumer_phone and consumer_email
included in the query? Obviously you don't care if they have entries in them, and
you're not selecting any info out of them. Remove them and see what happens.
>>> [EMAIL PROTECTED] 02/09/01 11:41AM >>>
Can someone have alook at
Can someone have alook at the problem below please and advise. I am stumped.
Regards
> -Original Message-
> From: jmydde - James Myddelton
> Sent: 09 February 2001 16:33
> To: lerobe - Lee Robertson
> Cc: rkilbe - Robert Kilbey
> Subject: [ Danone ] - Hung Oracle Query
>
>
>