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
- 5475 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 uses of a database trigger?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How can we delete duplicate rows in a table?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How to open and close an explicit cursor in oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
State and explain the different types of data models?
Explain the use of full option in exp command.
How to use "for" statements in oracle?
Can you have more than one content canvas view attached with a window ?
