Post reply

Table Performance

  • December 21, 2006 at 11:11 pm

    #679644

    Hi.

    SQL's answer to the "Oracle Materialised view" is the "SQL Indexed View"

    See:

    http://www.microsoft.com/technet/prodtechnol/sql/2005/ipsql05iv.mspx

     

  • December 21, 2006 at 11:22 pm

    #679646

    Rajesh,

    What feeds the proc you just posted?  A GUI, a batch job, another proc? or ???

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • December 21, 2006 at 11:38 pm

    #679649

    Yes I ran the Index Tuning Wizard which recommended a clustered Index on ATTRIBUTE_ID

  • December 21, 2006 at 11:39 pm

    #679650

    I use GUI to run the wizard...

  • December 21, 2006 at 11:40 pm

    #679651

    Sorry I use a GUI to feed the Proc.

  • December 22, 2006 at 1:48 am

    #679664

    Raj

    I think you said earlier that you'd tried with an index on that column and there was no improvement.  Please will you post an execution plan for when you have no index on the column, then create an index (I would recommend non-clustered unless (a) you don't already have a clustered index and (b) the table rarely or never gets updated - unlikely as you said it's increasing expontentially).  Post the code that you used to create the index.  Then run dbcc freeeproccache and post the execution plan for the query again.

    By the way, is auto update statistics enabled for your database?

    I don't recommend doing the above on a production server during business hours since it may have an adverse effect on your application or other applications using the same server.

    John

Viewing 6 posts - 16 through 20 (of 20 total)

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