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 difference between SQL and SQL*PLUS?

1 Answers  

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

1 Answers  

---

What is a connect identifier?

0 Answers  

---

Explain what are the different type of segments?

0 Answers  

---

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

0 Answers   Wipro,

---

What is a synonym? What are its various types?

0 Answers  

---

i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?

7 Answers   HCL, IBM,

---

Is it possible to disable the parameter from while running the report ?

1 Answers   Honeywell, Oracle,

---

How to define a cusotmer as a supplier in ORACLE R12

0 Answers   Intelligroup,

---

What is the difference between column level constraints and table level constraints?

14 Answers   IBM, TCS,

---

What is dictionary cache ?

2 Answers  

---

What is the usage of synonyms?

0 Answers  

---