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
- 5327 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 the different types of database objects?
What is meant by joins?
How to turn on or off recycle bin for the instance?
How translate command is different from replace?
What is the minimum client footprint required to connect c# to an oracle database?
Why do you create or replace procedures rather that drop and recreate.
Difference between pre-select and pre-query
What is the difference between view and materialized view in Oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
what are archived logs?
What are the major difference between truncate and delete?
What does sharding mean?
How many types of database triggers exist?
What is bulk collect in oracle?
How to call a stored function in oracle?
