Interested to Buy Any Domain ? << Click Here >> for more details...
how to code performance tuning of oracle PL/SQL? can any body
send me the perfect answer?
- 1 Answers
- 5478 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 |
What is a trace file and how is it created in oracle?
What is a trigger and what are its types in oracle?
What is the difference between Outer join and Full outer join?
What to do if the startbd.bat failed to start the xe instance?
What is oracle used for?
Where do you use decode and case statements?
How to find out what oracle odbc drivers are installed?
What are the different types of partitions in oracle?
What is an Oracle index?
What are main difference between Stored Procedure and Functions.
Explain compound trigger in oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Oracle General 
