Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7577 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
What is a table partition?
What is self-join and what is the requirement of self-join?
Is left join inner or outer?
What does stand for in sql?
What do you understand by exception handling in pl/sql?
explain the difference between delete , truncate and drop commands? : Sql dba
What is the function that is used to transfer a pl/sql table log to a database table?
What are the advantages of sql? Explain
What is restrict in sql?
Is record in pl sql?
Can you join a table to itself?
Can you selectively load only those records that you need? : aql loader
Does truncate require commit?
tell us something about heap tables. : Sql dba
what are the different functions in sorting an array? : Sql dba
