Re: Help with composite indices

Hi, I'll answer the order by question. You can use a composite index on (id, date) for an order by id, date OR an order by id I believe that this index can also be used for a join but I'm not positive. Also, the fact that the combo of id and date makes the index unique is a definite plus. -Bill > > I've read how to create a composite index, but I'm unsure about > how to use one to order output or join tables. In my db, I have > tables with company id's and dates, with the combination of > id and date being unique. So I can create an index on (id, date). > Can I use that index for joining tables? > Can I use that index when I come to the "order by" part of a > select statement? > > Many thanks. > -- > -------------------------------------------------------------------- > Bradford Young E-mail: byoung@cornercap.com > Cornerstone Capital Corp. Tel: (404) 870-0700 > Atlanta, GA Fax: (404) 870-0770 > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com