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
- 7563 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
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is difference between mysql and postgresql?
Is sql a dbms?
can sql servers linked to other servers like oracle? : Sql dba
Is microsoft sql free?
Why is pl sql used?
how is exception handling handled in mysql? : Sql dba
What is synchronized subquery?
how to include comments in sql statements? : Sql dba
What is sqlcommand?
How to use sql statements in pl/sql?
how to convert numeric values to character strings? : Sql dba
Is left join same as join?
What is pl sql architecture?
What are the commands used in sql?
