Bill, so, this would be a system that deals with subscriptions? Steve in Memphis
----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, October 20, 2003 5:28 PM Subject: [RBASE-L] - Re: index on multiple columns > On Mon, 20 Oct 2003 15:22:53 -0700, Alan Wolfe wrote: > > >when you select from the table does it use the index transparently or is > >there special syntax to use it? > > Razzak's note should be helpful, here, too. In general, R:Base makes the > very best guess it can. If you design your query well, and have created the > appropriate index, and have recently done a RELOAD or a PACK, R:Base is > likely to use the right index and do it very well. > > I have a very complicated index that is based on a combination of > streetaddress, city, state, and zip, that speeds up a search for duplicate > addresses. We want to mail only one copy of a magazine to an address. > The indexed-only retrieval of the SELECT COUNT (*) that uses this index is > very productive, compared to other methods we tried. > > Bill >
