<< 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
