ahh i shoulda said rtgm (: when you select from the table does it use the index transparently or is there special syntax to use it?
----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, October 20, 2003 2:47 PM Subject: [RBASE-L] - Re: index on multiple columns > On Mon, 20 Oct 2003 14:36:20 -0700, Alan Wolfe wrote: > > >hello, sorry if i should just rtfm but i was wondering, last night i heard that > you could set up an index on multiple columns without storing the > concatenation of those columns. > > Alan, > > Yes, it's part of SQL: > > CREATE INDEX mynewindexname ON tablename + > (firstcolunmname, secondcolumnname) > > There are syntax variations for unique indexes, and for descending > indexes. If you decide to read the fabulous manual, look under CREATE > INDEX. > > Bill >
