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?
- 2 Answers
- 6959 Views
- HSBC, I also Faced
- E-Mail Answers
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
How does sql profiler work?
What does select top 1 do in sql?
How do I count rows in sql?
How to use boolean type in select statement?
What are field types?
What are different types of indexes?
What is the advantage of nosql?
What is the mutating table and constraining table?
Explain the advantages and disadvantages of stored procedure?
Why stored procedure is faster than query?
how to enter characters as hex numbers? : Sql dba
What is a join query?
What is a common use of group by in sql?
How do you update f as m and m as f from the below table testtable?
what are all the different normalizations? : Sql dba
