FYI: If you have a very small number of rows in the table and index will make it slower, rather than faster.
On 11/21/05, Wilfried Mestdagh <[EMAIL PROTECTED]> wrote: > Hi Bert, > > >>'select distinct Name ' + > >> 'from Rx ' + > >> 'where RxDT >= ' + DT + ' ' + > >> 'order by Name' > > One thing is not yet clear to me. That is the 'distinct'. To have this > as fast as possible I have to make also a separate index on "RxDt, > Name". Is that correct ? (or the way around: "Name, RxDt" ?)
