Answer / bijaylaxmi

sql>create bitmap index <bitmap index name>
on tablename(column name);
e.g-create bitmap index empbitmapjob on emp(job);
This is the syntax for bitmap index.

What is dirty read?

0 Answers  

---

What is save transaction and save point?

0 Answers  

---

why SQL server is more used to store database rather than Access

2 Answers  

---

How are SQL Server databases physically stored under Windows 2000?

1 Answers  

---

How many types of Outer Joins?What are they?

1 Answers  

---

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 Answers  

---

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  

---

How to genrate automaticlly empid like gt001

4 Answers  

---

What number aggregate functions are accessible there in sql?

0 Answers  

---

How to add more data to the testing table in ms sql server?

0 Answers  

---

Explain cursor as data base object?

0 Answers  

---

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

---