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
