If you have table.columnA and table.columnB and columnA AND columnB participate in a compound PK or FK or Unique, you will definitely get much better speed by adding in addition to the PK or FK or Unique, a SINGLE COLUMN INDEX on columnA and columnB. There have been some recent changes to 6.5++, such that you are pretty well protected from adding an exact DUPICATE index, R:Base simply won't let you do it in 1.858. We have some compound 3 and 4 and 5 column PKs and FKs, and in some cases, each of the 4 columns also has its own individual single column index. In a multi-user setting this seems to make a big noticeable difference. Harlan
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of A. Razzak Memon Sent: Tuesday, October 01, 2002 12:57 AM To: [EMAIL PROTECTED] Subject: RE: indexing speed At 06:44 PM 9/30/2002 -0500, Phil Nolette wrote: >... Can you get the CD of last year's conference? Phil, Call 724.733.0053 or contact RBTI Sales Team at mailto:[EMAIL PROTECTED] Very Best Regards, Razzak. ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
