Composite Index

Results 1 to 2 of 2

Thread: Composite Index

  1. #1
    Rips Guest

    Default Composite Index

    Hi,<BR><BR>If you&#039;ve got say a Country table:<BR><BR>CountryID CountryName<BR><BR>and a Resort table:<BR><BR>ResortID CountryID BestMonth<BR><BR>Say you join the two tables with<BR><BR>SELECT dbo.Country.CountryID, dbo.Country.CountryName, ResortID, BestMonth<BR>WHERE dbo.Country.CountryID = dbo.Resort.CountryID AND BestMonth = [variable]<BR><BR>Then in the Resort table should you make a composite index of (CountryID, BestMonth) or two seprate indexes?

  2. #2
    Lurker Guest

    Default RE: Composite Index

    2 separate ones

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts