Re: [PERFORM] Index not used in query. Why?

2004-10-20 Thread Thomas F . O'Connell
ake this query a little more faster. Suggestions? Regards, Andy. - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Andrei Bintintan" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, October 19, 2004 7:52 PM Subject: Re: [PERFORM] Ind

Re: [PERFORM] Index not used in query. Why?

2004-10-20 Thread Contact AR-SD.NET
an" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, October 19, 2004 7:52 PM Subject: Re: [PERFORM] Index not used in query. Why? > "Andrei Bintintan" <[EMAIL PROTECTED]> writes: > > Hi to all! I have the following query. The execution time is very

Re: [PERFORM] Index not used in query. Why?

2004-10-19 Thread Tom Lane
"Andrei Bintintan" <[EMAIL PROTECTED]> writes: > Hi to all! I have the following query. The execution time is very big, it > doesn't use the indexes and I don't understand why... Indexes are not necessarily the best way to do a large join. > If I use the following query the indexes are used: The