|Trying to pack the index on 'TranType'
| kept throwing me out of RBase.
=======================================
Karen,
Sounds like you've got some bad data in the column TranType (e.g., stray
ASCII characters). To check for this, try the following command and look
for something weird in the output: SELECT DISTINCT TranType FROM tablename
---------------------------------------------------------------------------
Eric M. Bienstock, Ph.D.
Database Development, etc.
Authorized R:BASE Developer
Eric M. Bienstock & Associates, Inc.
day: 212-978-7948 eve: 973-763-8650(8)
FAX: 775-254-2109 [EMAIL PROTECTED]
http://mywebpages.comcast.net/ericmb/
---------------------------------------------------------------------------
----- Original Message -----
From: "tellef" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 24, 2002 4:41 PM
Subject: RE: Using index is slower
| 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/
================================================
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/
