what are the methods using performance tunning in sql and
pl/sql
Answer Posted / vyshak
1.tracing
2.explain plan
3.auto tracing
4.AWR reports
5.using v$views
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
what is the difference between blob and text? : Sql dba
What do we need to check in database testing?
What are the parts of a basic sql query?
explain the advantages and disadvantages of stored procedure? : Sql dba
when MSQL8.0 is in market
Is sql low level language?
What is difference between joins and union?
Is sql easier than java?
Is progress software supports to ( pl/sql )?
What are the steps for performance tuning.
When to use inner join and left join?
What are the different types of functions in sql?
What is the difference between an inner and outer join?
How does a self join work?