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
- 5364 Views
- IBM, I also Faced
- E-Mail Answers
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
What are dml statements in oracle?
What is the database name in oracle?
Name the three major set of files on disk that compose a database in Oracle?
What is oracle instant client?
Explain the use of rows option in exp command.
How would you begin to troubleshoot an ORA-3113 error?
What are a cluster and non-cluster index?
How to convert characters to dates in oracle?
What is bind variable in oracle 11g?
Explain the difference between sql and oracle?
What are the uses of a database trigger?
How to use "out" parameter properly?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How many types of synonyms in Oracle?
How to generate query output in html format?
