Post reply

Indexes on Temp Tables

  • August 20, 2008 at 5:29 pm

    #123964

    Hello,

    I am using nested stored procedures. Created a temp table in the outer procedure. Inserting data into the temp table in the inner procedure.

    I created an index on the temp table using 'unique' constraint in the 'create table' syntax. However, the query plan still shows 'Missing Stats' for the temp table.

    The temp table is being used in the join statement specified in the outer procedure.

    I even tried creating the index using 'create index' in the outer as well as inner procedure but still get 'Missing Stats'.

    Any advice would be appreciated.

    Thank you.

  • August 20, 2008 at 5:39 pm

    #860955

    Are the missing stats on an unindexed column?

    You could manually create the statistics in your stored procedure. I've done that many times.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply