Answer / guest

WE CAN EVALUATE THE QUERY PERFORMANCE BY RUNNING THE
EXECUTION PLAN OF THE QUERY.IF THE QUERY NEEDS ITS
PERFORMANCE TO BE OPTIMISED THEN WE WILL BE CREATE A VIEW
FOR THE TABLE USING 'WITH SCHEMA BINDING ' OPTION ,THEN
SUBSEQUENTLY CREATE A MATERIALISED VIEW USING INDEX
DEFINITION.FINALLY CHECK FOR THE EXECUTION PLAN (THAT
PREVENTS THE EXPENSE OF I/O READS).

Why we are using the sql language?. What is the purpose of using this?

2 Answers  

---

UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,

---

What is 2nf normalization?

0 Answers  

---

Why do we need normalization?

0 Answers  

---

What is lock escalation? : sql server database administration

0 Answers  

---

---

Write a SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

---

What do you understand by intent locks?

0 Answers  

---

How to create a store procedure with encryption?

0 Answers  

---

To find second largest salary in Employee table

17 Answers   CSS,

---

Explain the truncate command?

0 Answers  

---

Does index slows down insert statements?

0 Answers  

---

What is a virtual table in sql?

0 Answers  

---