can you explain performance tunning in oracle(sql,PL/SQL)
- 2 Answers
- 3908 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sushant
It is just to check whether the query which we provide is
quiet simple n takes less time to compile as compared to
other querys !!!
Mostly its a DBA part !!
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sudipta santra
First u need to take explain plan of the proposed query then
you can identify for which join condition is costlier. By
watching this then you can modify the condition logic of the
query.
There are so many logic for make a query tune.
| Is This Answer Correct ? | 1 Yes | 0 No |
hai, when to use char and varchar2....?
What is use of oracle?
What is instant client oracle?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What is connection pooling in oracle?
How to call a stored procedure inside a trigger? Give an example.
How to list all user accounts in oracle?
what is the difference between primary key & foreign key?
57 Answers CTS, Infosys, La Multi, Sparsh, Wipro,
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What is a Data Dictionary ?
How to define a data source name (dsn) in odbc manager?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
Oracle General 
