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
2. Two or more branch nodes.
|Is This Answer Correct ?||1 Yes||5 No|
What do you mean by dbms? What are its different types?
Write the alter statement to enable all the triggers on the t.students table.
Why select is used in sql?
What is mutating trigger?How to avoid it??
How many columns should be in an index?
Can you have a foreign key without a primary key?
What is java sql drivermanager?
What is partition by in sql?
How to add a column ‘salary’ to a table employee_details?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Can we have exception part in trigger ?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql