Interested to Buy Any Domain ? << Click Here >> for more details...
Initially question was asked to mention the types of indexes.
Then asked about BITMAP INDEX and B-Tree Index
- 2 Answers
- 7174 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / slokh
Bitmap index is a type of index created on the basis of the
column having low cardinality like. index created on the
column like 'gender' etc.
B-tree or binary index is created on the column contains
wide range of values like 'name' column.
note:- more than one index is created on the table.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
how to get a list of columns in an existing table? : Sql dba
How global cursor can be declare with dynamic trigger ?
What is pl sql script?
What is t-sql? : Transact sql
How do I debug a stored procedure?
How do we accept inputs from user during runtime?
How can the performance of a trigger be improved?
how to convert numeric values to character strings? : Sql dba
discuss about myisam index statistics collection. : Sql dba
What is the need of merge statement?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Is sql a scripting language?
Why plvtab is considered as the easiest way to access the pl/sql table?
What is data abstraction in sql?
What are analytic functions in sql?
