Bill: >Don't reload, just rebuild the indexes on the indexed columns in the >tables you are querying.
>To find the names of the indexes, type: >LIST INDEX FOR tablename >and see the result in the first column. Then type: >PACK INDEX indexname >for each index. Run your queries again, and see if that doesn't improve >things. Thank you very much for the reminder (and everyone else too) about how reloading recalcs the index statistics. I liked your idea so I tried it. Guess what. Trying to pack the index on 'TranType' kept throwing me out of RBase. I could pack any other index on that table. Hmmmm... So I dropped the index then rebuilt it. Tested the same query, using the index and not using the index (by putting parens around the value). The results: Not indexed: 2 seconds Indexed: 21 seconds This is a copy of the database from about a year ago so I have no idea what their database looks like now (new subcontracting job -- have never dialed into the client). So I guess this means it's just a bad choice for an index! 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/
