Post reply

performance search in table

  • January 27, 2012 at 11:30 pm

    #254431

    Hi

    I have a table with 40 field and 2 milion record

    I have a primary key that is identity

    when I want search a record by certain condition the time of search is very long

    because number of record is very thick

    please help me that i how enhance performance of my search?

    thanks a lot

  • January 28, 2012 at 1:17 am

    #1439658

    Hi

    I dont know what SQL knowledge you already have....but from your question it would appear that you are not too sure about indexes and how/where to use them.

    here is a good link that explains indexes in an easy to follow format

    http://www.sqlteam.com/article/sql-server-indexes-the-basics

    hope this helps

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

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

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