Post reply

create an Index.

  • June 25, 2010 at 11:46 pm

    #220538

    Hi,

    below is my sql query,i want to create an index bcz my sql query result showing slow.

    To increase the performance on which column i have to create an Index.

    [font="Arial Black"]select e.product_id,pm.product_code,cm.crop_name from tbl_eventcompletion e inner join tbl_Productmaster pm on e.product_id=pm.product_id inner join tbl_Cropmaster cm on pm.crop_id =cm.crop_id where e.event_compl_id='" + streventCompl + "'"; [/font]

  • June 26, 2010 at 3:08 am

    #1185335

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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