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.

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---

Describe and explain about SQL native client?

1 Answers  

---

Can a cursor be updated? If yes, how you can protect which columns are updated?

1 Answers  

---

What is a system database and what is a user database?

1 Answers  

---

Does order by actually change the order of the data in the tables or does it just change the output?

1 Answers  

---

Define Unique Key?

1 Answers   HCL,

---

There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9

12 Answers   RBS,

---

What is named query? : sql server analysis services, ssas

1 Answers  

---

How to add an address record into adventureworkslt?

1 Answers  

---

What it means to be triggered?

1 Answers  

---

wht is normalization?can u explain me in detail?

9 Answers   TCS,

---

Why should we go for stored procedures? Why not direct queries?

1 Answers  

---