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.

what is performance tunning in sql server ? explain.

1 Answers   Thomson Reuters,

---

Explain user defined views?

0 Answers  

---

If a stored procedure is taking a table data type, how it looks?

1 Answers  

---

can a table be moved to different filegroup? : Sql server administration

0 Answers  

---

Explain the cursor lock types?

0 Answers  

---

When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,

---

What are primary keys and foreign keys?

4 Answers  

---

what is procedure in sql?

2 Answers   Millennium, SQL,

---

What command is used to rename the database?

0 Answers  

---

Explain candidate key, alternate key, and composite key?

0 Answers  

---

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

0 Answers   ABC,

---

What is the difference between a "where" clause and a "having" clause?

0 Answers  

---