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.

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.

Can we delete column in sql?

0 Answers  

---

What is rownum in sql?

0 Answers  

---

Explain the significance of the & and && operators in pl sql.

0 Answers  

---

What is group by in sql?

0 Answers  

---

How can I tell if sql is running?

0 Answers  

---

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

8 Answers  

---

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  

---

How many postgresql users are there, worldwide?

0 Answers  

---

How does one load ebcdic data? : aql loader

0 Answers  

---

Does SQL*Plus contains pl/sql Engine?

1 Answers   TCS,

---

What are analytical functions in sql?

0 Answers  

---

What will you get by the cursor attribute sql%rowcount?

0 Answers  

---