how to code performance tuning of oracle PL/SQL? can any body
send me the perfect answer?
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 do you mean by cdb and pdb in oracle 12c?
how to insert data into partitioned table partition done by Range partition
What is tns service name?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How do we represent comments in oracle?
How to recover a dropped table in oracle?
What is the difference between post-database commit and post-form commit?
Why does for update in oracle 8 cause an ora-01002 error?
what is the scripts in data base?
How to add a new column to an existing table with a default value?
What are Schema Objects ?
primary key is foreign key for the same table?