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
- 7446 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 to create your own reports in sql developer?
how to check server status with 'mysqladmin'? : Sql dba
List different type of expressions with the example.
How do you optimize a stored procedure query?
How do you change a value in sql?
What is linq to sql?
How do you sort in sql?
Is left join same as join?
How do you concatenate in sql?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What are secondary keys?
what are the advantages of mysql in comparison to oracle? : Sql dba
What is clause in sql?
what is collation? : Sql dba
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
