SQL Server Performance

Point of view about index creation

Discussion in 'SQL Server 2008 Performance Tuning for DBAs' started by AMOURGH, Mar 2, 2009.

  1. AMOURGH Member

    Hello Everybody,
    i have a table BusineesGeoChildren(BusinessGeoId,BusinessGeoChildId).
    Primary key=(BusinessGeoId,BusinessGeoChildId).
    but the main select against this table is(the most used query used for this table):SELECT BusinessGeoChildId FROM BusineesGeoChildren WHERE BusinessGeoId=BusinessGeoId0.
    Is it recommended to create a nonclustred index on the column BusinessGeoId?
  2. Adriaan New Member

    In SQL Server, a primary key already includes an index (in fact like all unique constraints). Since the BusinessGeoId column is the first column on the index, you do not need a separate index.
  3. AMOURGH Member


Share This Page