Interested to Buy Any Domain ? << Click Here >> for more details...
How can analyze query after generating explain plan ?
- 2 Answers
- 7960 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 |
what are the advantages of primary key over unique+notnull
7 Answers Consultancy, LGS, Oracle,
how to shut down the server with 'mysqladmin'? : Sql dba
What is the difference between having and a where in sql?
What is raw datatype in sql?
how to use regular expression in pattern match conditions? : Sql dba
What is the difference between RDBMS and DBMS?
20 Answers Practical Viva Questions, Sapient, Stag Computers,
What is sql and its types?
what are Dynamic SQL statements?
What is a design view?
how to extract a unit value from a date and time? : Sql dba
what are the disadvantages of mysql? : Sql dba
What is mutating error?
-
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)
