Post reply

Indexing

  • April 13, 2010 at 11:20 pm

    #233878

    hi

    I have clustered index on tradedate,clientid and trade id

    CREATE CLUSTERED INDEX [tbl_trades_cidx] ON [trades].[tbl_Trades]

    (

    [TradeDate] ASC,

    [ClientID] ASC,

    [TradeID] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [trades]

    GO

    will this index will get used when i execute a query with only tradeid in the where condition. Please help me.

    Also give me some tips on using indexing. they are expecting nearly 1 lakh records perday in this table. i already did table partitioning monthwise.

  • April 14, 2010 at 3:04 am

    This was removed by the editor as SPAM

  • April 14, 2010 at 4:57 am

    #1151219

    vmssanthosh (4/13/2010)

    Also give me some tips on using indexing. they are expecting nearly 1 lakh records perday in this table. i already did table partitioning monthwise.

    You should analyze queries which are heavily used, study their execution plans and plan out ur index structure accordingly.


    Pradeep Singh

  • April 14, 2010 at 6:21 am

    #1151266

    Thanks for your reply.

    Can you tell me how to read the execution plan. any links please..

  • April 14, 2010 at 6:24 am

    #1151271

    You can begin with Grant's article.

    http://www.simple-talk.com/sql/performance/execution-plan-basics/%5B/url%5D


    Pradeep Singh

Viewing 5 posts - 1 through 4 (of 4 total)

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