Thanks Larry and Bill
I still have one of these from years ago that I have not cleaned up.
I do not have any real speed issue in that table so I never took the time
to clean it up or test if it is faster with or without an Index.
Marc
--------------------------------------------------
From: "Lawrence Lustig" <[email protected]>
Sent: Wednesday, January 06, 2010 8:57 AM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - Re: Update command taking forever
<<
Is it OK to index a Y/N column if you have 95% N and 5% Y
and you only search for Y?
I was wondering if those 5% Y's would pop up faster compared
to RBase going row by row.
In this case, you would probably be better off removing the column
entirely from the table and instead use a second table containing only the
PK values from the main table that fall into the "Y" category. This would
allow you to quickly find the Y records without indexing overhead on the
main table and would save you the storage space for all the "N" values in
the main table.
--
Larry
