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
- 7422 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 are inbuilt functions in sql?
What is Difference Between Unique and Primary Key Constraints?
Why is sql*loader direct path so fast?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
How delete all data from all tables in sql?
Can function return multiple values in sql?
how to calculate the difference between two dates? : Sql dba
What is using in sql?
what is union? : Sql dba
Where can I learn sql for free?
What is cold data?
Which command is used to delete a package?
What is a database? Explain
Why do we use triggers?
Define commit, rollback and savepoint?
