can you explain performance tunning in oracle(sql,PL/SQL)
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 |
How to recover a dropped index?
what is the syntax of ALTER command?
how can we write trigger in trigger???????? can we write one trigger on two table???
dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.
How to get execution path reports on query statements?
What is the quickest way to export a table to a flat file?
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
How to execute a stored procedure in oracle?
What is literal?
Name the three major set of files on disk that compose a database in Oracle?
What is a table index in oracle?
How to list all indexes in your schema?