Thread: PLANs

    #1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2006
    Posts
    205
    Rep Power
    19

    PLANs


    Why don't you open another thread asking what an explain plan is, how to have the database spit it out and, last but not least, how to read it?
    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?

    Comments on this post

    • pabloj agrees : Well done
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,517
    Rep Power
    543
    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.
    Last edited by pabloj; October 28th, 2006 at 01:43 PM.

IMN logo majestic logo threadwatch logo seochat tools logo