hi again,
I have question like that:
SELECT /*! SQL_BUFFER_RESULT */
DISTINCT branza.branzaid, branza.branzanazwa
FROM branza, klientbranza, klientwojewodztwo
WHERE
branza.branzaid = klientbranza.branzaid
AND klientbranza.klientid = klientwojewodztwo.klientid
AND wojewodztwoid =9
ORDER BY bsort
I really hate to do this to you but if I tried to answer your questions I
would be copying from the book anyway. There is a section in the manual
that deals specifically with query optimization. It covers index creation
and usage, when an order by will and won't use and index and a bunch of
think I don't understand that and I decided to write to the list
with respect
DeRyl
- Original Message -
From: [EMAIL PROTECTED]
To: DeRyl [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, October 27, 2004 3:53 PM
Subject: Re: help with proper conditions and indexes needed
I really