Results 1 to 4 of 4

Thread: procedure plan

  1. #1
    Join Date
    Jun 2003
    Posts
    140

    Unanswered: query plan

    hi all

    where does the query plan is stored ?
    is it sysprocedures table?
    also when query plan is generated at compilation time or execution time ?

    any good links or docs regarding query plan structure 'll be much helpful




    thx
    perl
    Last edited by perl; 12-30-03 at 08:42.

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    In the procedure cache
    Check Perf & tuning Guide

  3. #3
    Join Date
    Jun 2003
    Posts
    140
    Hi Thanx for reply

    i cheked the guide and got it but 1 little quest wht happens to procedure cache after restart ? I mean doesnt procedure cache get cleared after restart ?


    thx again
    perl

  4. #4
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Sysprocedures contains entries for each view, default, rule, trigger, procedure, declarative default, and check constraint. The plan or sequence tree for each object is stored in binary form.

    The query plan is in the procedure cache. It can be in the table sysqueryplans if you're using the abstract plans. In the first execution (or if the previous query plan went out the procedure cache), it is not in the the procedure cache => the query plan must be recalculated and enter in the procedure cache

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •