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 |
What is delimiter in pl sql?
How to add, remove, modify users using sql?
What is the basic difference between a sql and stored procedure ?
how to sort records in sql?
What are the different dcl commands in sql?
Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index
Explain the order of sql statement execution?
Can one improve the performance of sql*loader? : aql loader
Is sql microsoft?
How to use sql statements in pl/sql?
how instead of triger is helpful for mutating tables errors handlling ?
hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com