Answer / bala

By avoiding sql statements & select INTO kind of statements.
To improve better creating cursors to hold data.
Indexing is the way to tune the database tables.
so, mostly try to avoid Hard Coding in the select
statements..

Answer / ramprasad.s

hi



using oracle-Tuning




sun_ramprasad@yahoo.com

what are myisam tables? : Sql dba

0 Answers  

---

What is primary key secondary key alternate key candidate key?

0 Answers  

---

What are views in sql?

0 Answers  

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

0 Answers  

---

Why do we need cursor in pl sql?

0 Answers  

---

Is sql pronounced sequel or sql?

0 Answers  

---

Is postgresql a nosql database?

0 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

What is the difference between inner join and left join?

0 Answers  

---

What are the uses of merge?

0 Answers  

---

what are different types of keys in sql?

0 Answers  

---

How do you copy a table in sql?

0 Answers  

---