Re: help with proper conditions and indexes needed

2004-10-27 Thread DeRyl
correction so I 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

Re: help with proper conditions and indexes needed

2004-10-27 Thread SGreen
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 ot

help with proper conditions and indexes needed

2004-10-27 Thread DeRyl
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 A