Initially question was asked to mention the types of indexes.
Then asked about BITMAP INDEX and B-Tree Index
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / brajesh kr.
Bitmap:- index is special kind of index that uses bitmap .
it significant space and performance advantage over
structure for such data. it is also useful for unique value
data. it use bit arrays and answer queries by performing
bitmap logical operations on these bitmap.
B-Tree:-databse server uses a b-tree strucruyre to organize
index information shows that afully developed b-treee index
is composed of that following
1.Oneroot nodes
2. Two or more branch nodes.
Is This Answer Correct ? | 1 Yes | 5 No |
Difference between IN and EXISTS
How to combine two stored procedures in sql?
Is it possible to sort a column using a column alias?
Can delete statement be rollbacked?
Why do we use subquery?
Is clustered index a primary key?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
Does sql*plus have a pl/sql engine?
Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy
explain mysql aggregate functions. : Sql dba
How pl/sql source code can be protected?
What does rownum mean in sql?