I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?
Answer Posted / thanjairajan@gmail.com
You Can use Bitmap Index. Because while no.of unique record is small than no.of total record, we can use bitmap index. i.e we can use bitmap index in low cardinality column.
For example a table contain name,address,sex column. in sex column may be two values. i.e male and female. so this distinct values small but no.of total records is high.
So in this situation we can use bitmap index.
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Who developed sql?
How can we avoid duplicating records in a query?
Explain the working of foreign key?
What is null in pl/sql?
What is nosql example?
Why do we use joins in sql?
What is the difference between in and between in sql?
How do I find duplicates in two columns?
What is left join example?
What are predefined functions in sql?
What is 19 null in sql?
Which join condition can be specified using on clause?
How delete all records from table in sql?
How do I delete a trigger?
What is clustered index in sql?