Interested to Buy Any Domain ? << Click Here >> for more details...
How can analyze query after generating explain plan ?
- 2 Answers
- 8151 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 |
When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?
2 Answers Accenture, Unisoft Infotech,
What are different types of tables in sql?
What is a clob in sql?
What is difference between joins and union?
What does plv msg allows you to do?
Explain isolation levels. : Transact sql
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
What are inner and outer joins examples of both?
How many types of triggers are there in pl sql?
What is difference between my sql and sql?
cursor types? explain with example programs?
What is the left table in sql?
-
Oracle (3253) - 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)
