Interested to Buy Any Domain ? << Click Here >> for more details...
How can analyze query after generating explain plan ?
- 2 Answers
- 8064 Views
- Thermotech, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chiranjeevi
After generating explan plan the out put of the query
stored in plan_table.from this table if you finding any
table access (full) in output,the query having perfomence
problem.
according you can create the index or primary key or unique
in proper table.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / azuan
example
explain analyze select br_loc,count(insp_id) from insp where
date_create between '2010-07-01 00:00:00' and '2010-07-31
23:59:59' group by br_loc
| Is This Answer Correct ? | 1 Yes | 0 No |
How many commands are in sql?
Name three sql operations that perform a sort.
Can a foreign key have a different name?
Explain the purpose of %type and %rowtype data types?
what is rdbms? : Sql dba
How do I save the results of sql query in a file?
Explain foreign key in sql?
How to display the records between two range in Oracle SQL Plus?
what are the different type of normalization? : Sql dba
What is memory optimized table?
What can you do with pl sql?
What are sql ddl commands?
-
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)
