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
- 6754 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 use case expression? : Sql dba
what is a tablespace? : Sql dba
What is meant by temporal data?
Explian rowid, rownum?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
What are literals in sql server?
What is percent sign in sql?
What is synonyms?
What is use of term?
what is 'mysqlimport'? : Sql dba
What is pl/sql table? Why it is used?
Is foreign key mandatory?
what are the 'mysql' command line options? : Sql dba
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What does truncate mean in sql?
