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.

How can we find duplicate records in a table?

0 Answers  

---

explain the delete statements in sql

0 Answers  

---

Types of optimization?

6 Answers   Microsoft,

---

what is the purpose of update command in oracle?

7 Answers   MBT,

---

How to revise and re-run the last sql command?

0 Answers  

---

What is trigger and stored procedure in sql?

0 Answers  

---

What does sign mean sql?

0 Answers  

---

what are the nonstandard string types? : Sql dba

0 Answers  

---

How do I find duplicates in the same column?

0 Answers  

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

Why truncate is faster than delete?

0 Answers  

---

How do I run pl sql in sql developer?

0 Answers  

---