Interested to Buy Any Domain ? << Click Here >> for more details...
can you explain performance tunning in oracle(sql,PL/SQL)
- 2 Answers
- 4552 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 |
Can we create more than one constraint to column ?
What is forall Statement ?
Explain what are the advantages of views?
WHAT IS ecc 6.0
What is the sql query to concatenate column values from multiple rows in oracle?
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.
How to start a specific oracle instance?
If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?
What is ordinary table in oracle?
How to generate query output in html format?
i want department wise maxmum salary and empolyee name
How many types of tables supported by oracle?
Oracle General 
