Karen At the developers conference, Wayne Ericson presented 'Finding and Fixing Broken Pointers/Indexes'. If you check the documentation it may help you with index performance and fixing broken pointers.
Hope this helps. Bill Eyring -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of tellef Sent: Friday, April 12, 2002 6:14 PM To: All Subject: Using index is slower Hello! I have a view that will hold a lot of data. I wanted to search it 2 ways for these where clauses: repdate between .... and trantype <> 'fr' repdate between .... and trantype = 'fr' The first search is very fast. The second search I had to reboot RBase after it was still chugging after 20 minutes. For the heck of it I changed it to repdate between .... and trantype = ('fr') Now it's as fast as the first search! Rbase won't use indexes when the where clause is "<> 'fr'", so I had to do the same for the "= 'fr'". Putting it in parenthesis did the job! Put this on your list of "gotta remember to try that the next time I have a slow view".... Karen ================================================ 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/
