how to code performance tuning of oracle PL/SQL? can any body
send me the perfect answer?
Answer Posted / 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 |
Post New Answer View All Answers
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What happens if you lost a data file?
What privilege is needed for a user to query tables in another schema?
what are archived logs?
What are set operators?
What is a proxy class?
Can group functions be mixed with non-group selection fields?
What is instant client oracle?
What are the built-in functions used for sending Parameters to forms ?
What is set operator oracle?
How to define and use table alias names in oracle?
Write a syntax for update query in oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What happens to indexes if you drop a table?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?