Answer / suresh babu

We can create more number of indexes for a table.It required
separate memory space for each and every index.It will be
fast when using the search condition.

But if we are going to do some DML operations such as
insert,update,delete the server performance should reduce.

Answer / naren

it will allocate more space on disk.

Answer / guest

index reduce server preformance

What are the different types of join?

0 Answers  

---

What is a DBMS, query, SQL?

0 Answers   Maveric,

---

What is SQL server agent?

2 Answers   HCL, SAP Labs,

---

What is Index ? Explain its Types?

2 Answers   ADP,

---

What is trigger explain with program?

0 Answers  

---

---

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

---

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

0 Answers  

---

Are resultset updatable?

0 Answers  

---

What is the difference between seek predicate and predicate?

0 Answers  

---

What is the difference between commit and rollback?

0 Answers  

---

How to insert stored procedure result into temporary table?

0 Answers  

---