Answer / kt

There isn't any hard and fast rule for code optimization. U have to analyze the situation and act accordingly. :)You can either choose an RBO (Rule based optimization) or a CBO (Cost based optimization).But before that one of the simplest way to make ur queries faster is Indexing.
If your database table is huge and simple select statement takes ages to come out then you can go for Indexing of the table.For that u have to analyze which column to index. Generally we should index the column that we frequently use in our where clause. then you need to know what type of index to use. Default one is B* Tree.U can go for index on as many columns as u like but keeping the fact in mind that too much column indexing also eats some space of data dictionary.
Then you can also go for table partitioning, analyze statement, dbms stats gathering and so on.

What is the difference between formal parameters and actual parameters?

0 Answers  

---

What is raw datatype?

0 Answers  

---

How to filter out duplications in the returning rows using oracle?

0 Answers  

---

How to check database size in Oracle?

0 Answers   MCN Solutions,

---

What is the difference between a hot backup and a cold backup in oracle?

0 Answers  

---

if i am using dml statement in function. then i am writing select statement what was the output

2 Answers   MasterCard,

---

What are the types of synonyms?

1 Answers  

---

Can objects of the same Schema reside in different tablespaces.?

3 Answers  

---

What is meant by an index?

0 Answers  

---

what is a cartition product?

4 Answers  

---

Explain an index segment?

0 Answers  

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---