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
- 7673 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 meant by urlencode and urldocode? : Sql dba
Does sqlite need a server?
What is the difference between jpql and sql?
Explain the the update statement in sql?
what is column? : Sql dba
What is difference between rank () row_number () and dense_rank () in sql?
What is the difference between cross join and natural join?
What is pls_integer in pl sql?
How do I remove sql plus from windows 10?
What is a field in a database?
What is scalar function in sql?
Explain dml and ddl?
How do I save a sql query?
Can a table contain multiple primary key’s?
Explain the difference between rename and alias?
