Re: Can anyone figure out this MySQL query?

From: <do-not_at_spam.me>
Date: Wed, 30 Aug 2000 12:00:33 GMT
Message-ID: <39acf72e.85704937_at_news.arnes.si>

Thanks! I've tried the first two and it's working OK with the DISTINCT option, because I don't need duplicates. However the query is rather slow on my dataset which is almost 1 million Invoices - it takes about 12 minutes to complete the query. Do you think that indexes may speedup the query to, egad...a few seconds?

I will try the last solution you presented in the meantime and see how that pans out.

Thanks again,
Chris

On Wed, 30 Aug 2000 09:52:48 GMT, peterbroers_at_rhbcml.leidenuniv.nl (Theo Peterbroers) wrote:

>Simple, if you are only interested in a case with two customers:
>SELECT a.*
>FROM Invoices as a, Invoices as b
>WHERE a.CustomerNo in (1,2)
> AND b.CustomerNo in (1,2)
> AND a.CustomerNo <> b.CustomerNo
> AND a.HotelNo = b.HotelNo
>The trick is to use two aliases (a and b) for the same table.
Received on Wed Aug 30 2000 - 14:00:33 CEST

This message: [ Message body ]
Next message: Theo Peterbroers: "Re: Can anyone figure out this MySQL query?"
Maybe in reply to: do-not_at_spam.me: "Can anyone figure out this MySQL query?"
In reply to Theo Peterbroers: "Re: Can anyone figure out this MySQL query?"
Next in thread: Theo Peterbroers: "Re: Can anyone figure out this MySQL query?"
Reply: Theo Peterbroers: "Re: Can anyone figure out this MySQL query?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message