Post reply

index on child table advice

  • June 27, 2008 at 10:46 am

    #193263

    I have a child table containing ExpenseRequestLineItem with a foreign key to the parent table's ExpenseRequestID. The child table has no primary key of its own, but it does have a LineItem column. Would an index onthe LineItem column be recommended, or just have no index at all? Whould it be clustered or non?

  • June 27, 2008 at 1:47 pm

    #835614

    no way of answering that without knowing the types of queries run against the table.

    as ExpenseRequestLineItem is a foreign key good chance it is used in joins so an index would likely be useful on that, most often this would be a non-clustered index.

    ---------------------------------------------------------------------

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

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