Answer / arthanari r

When hte SQL statement is executed Oracle designs an
execution plan for it. This execution plan is basically a
step by step instruction for how the statement must be
executed. That is, the order in which tables are read, if
indexes are used, which join methods are used to join
tables and so on. The execution plan for an SQL statement
can be viewed with the explain plan statement. The query
execution plan is elaborated during an SQL statement's
parse phase.

Answer / racing

When the SQL statement is executed Oracle designs an
execution plan for it. This execution plan is basically a
step by step instruction for how the statement must be
executed. That is, the order in which tables are read, if
indexes are used, which join methods are used to join
tables and so on. The execution plan for an SQL statement
can be viewed with the explain plan statement. The query
execution plan is elaborated during an SQL statement's
parse phase.

Explain what are the different index configurations a table can have?

0 Answers  

---

what is Full Text Search ?

1 Answers   TCS,

---

What extended events?

0 Answers  

---

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

0 Answers  

---

what are candidate key, alternate key and composite key? : Sql server database administration

0 Answers  

---

---

How does normalization work?

0 Answers  

---

How to create a large table with random data for index testing in ms sql server?

0 Answers  

---

What is the difference between DTS and SSIS?

3 Answers   Allianz,

---

What are the different types of joins and what does each do?

2 Answers  

---

How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 Answers  

---

Which is the latest version of sql server and when it is released?

0 Answers  

---

Is sql server difficult to learn?

0 Answers  

---