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.

Is resultset an interface?

0 Answers  

---

What is the difference between composite index and covering index?

0 Answers  

---

How to stop log file growing too big?

0 Answers  

---

What are the grouping functions?

0 Answers  

---

What is difference between table aliases and column aliases? Do they affect performance?

0 Answers  

---

---

plz send every query in sql server2000

1 Answers   Infosys,

---

What is RAID and what are different types of RAID configurations?

8 Answers   Wipro,

---

Delete duplicate rows without using rowid.

0 Answers   Nagarro,

---

What are the options which must be set to allow the usage of optimistic models?

0 Answers  

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---

difference between truncate, delete aur drop?

2 Answers  

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---