Post reply

Index not used on Select *

  • March 28, 2004 at 6:29 am

    #500809

    Try putting a clusterad key on the table. And sort it by for example invoice date (first column) if it is a invoice table. Then we can talk more.

    Trust me. Your updates,deletes and insertes will not slow down. If anything they should speed up.

    Ask anybody. You should ALWAYS have a clusterad index on a table.

Viewing post 16 (of 15 total)

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