|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
October 28th, 2006, 11:32 AM
|
|||
|
|||
|
PLANs
Quote:
Can anybody explain me what PLAN is good for? Please don't tell me to go and read the documentation in the ApiGuide or such. I would like to hear the main reasons why should i use a PLAN, and how does it make my life easier?
|
|
#2
October 28th, 2006, 12:30 PM
|
||||
|
||||
|
The explain plan of a query shows you how the database server executes a query.
It is extremely useful to troubleshoot slow queries and check index usage. You can see it at work in this blog post.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias) Last edited by pabloj : October 28th, 2006 at 12:43 PM.
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > PLANs |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
