|
-
As long as the table is not updated /inserted frequently, bit map index is OK.
If your result set is going to be 12% of the rows from the 500,000 rows table, then I would not allow CBO to use neither bit map index nor the B-Tree Index, because it requires more I/O for reading Index and data blocks to figure out the result set. In this case I would choose full table scan, because the data is going to be present in LRU for longer time.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|