Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP
- 1 Answers
- 8766 Views
- TCS, I also Faced
- E-Mail Answers
Answer / s.panda
Step1: At first we need to identified the high load SQLs or
top SQLs that are responsible for performance problem or in
another word the sql that consume application workload and
system resources. We can easily identify them by reviewing
past SQL execution history available in the system.
Step 2: Now generate execution plan of those high load sql
statements and verify that the execution plans produced by
the query optimizer for these statements perform reasonably.
Step 3: Implement corrective actions to generate better
execution plans for poorly performing SQL statements. While
taking corrective actions there is many considerations.
| Is This Answer Correct ? | 3 Yes | 1 No |
What is the use of index in hive?
need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
What are reports usually used for?
What is the purpose of my sql?
What does closing a cursor do?
What is a primary key called that is made up of more than one field?
Can a trigger call a stored procedure?
Why does %isopen return false for an implicit cursor?
What is use of term?
Is sql a oracle?
what is rdbms? : Sql dba
Mention what are the benefits of pl/sql packages?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
