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 a SELECT FOR UPDATE cursor represent.?

1 Answers  

---

What is oracle and what are its different editions?

0 Answers  

---

What are the commands youd issue to show the explain plan for select

2 Answers  

---

How to lock and unlock a user account in oracle?

0 Answers  

---

difference between procedures and function?

7 Answers   IBM,

---

how many triggers we can create on a table

11 Answers   G2 Technology, TCS,

---

What is the difference between "as" and "is" in an oracle stored procedure?

0 Answers  

---

I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

2 Answers   Zensar,

---

What are data pump export and import modes?

0 Answers  

---

How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?

3 Answers   Digital Group,

---

What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?

1 Answers   TCS,

---

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

0 Answers   Wipro,

---