Post reply

How to base indexes on stored procedures

  • October 5, 2009 at 6:58 pm

    #138541

    Hi,

    Please help me with on how to base indexes on stored procedures

    Thanks

  • October 5, 2009 at 7:38 pm

    #1062058

    I'm not sure exactly what you mean by basing an index on a stored procedure. Can you give us a little more concrete example of what you are trying to accomplish?

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • October 5, 2009 at 8:55 pm

    #1062070

    You base indexes on the queries and joins that you need. Doesn't matter if they are in a stored procedure or not, you check the queries (SELECT, INSERT, UPDATE, DELETE) for the fields that make sense to index.

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

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