how to code performance tuning of oracle PL/SQL? can any body
send me the perfect answer?
- 1 Answers
- 4659 Views
- IBM, I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 1 Yes | 1 No |
Which database is better for os platform dependency?
Which is better Oracle or MS SQL? Why?
How to get execution statistics reports on query statements?
What is oracle sid?
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
How to commit the current transaction in oracle?
What would you do with an in-doubt distributed transaction?
Which Department has MOST NUMBER of employees?
8 Answers IBM, LeadSquared, Mastek,
What happens if the imported table already exists?
How to invoke the data pump import utility?
Why do we need integrity constraints in a database?
What are advantages of dateset in datastage?
Oracle General 
