Clustered Index HELP....

  • When working with a many to many senerio i understand this...

    But i have noticed in the adventures works database that there is a table in their that has a many to many and another table that is tied to the go between table...

    What is the logic behind having a date field to be envolved in with a go between like this..

    can some give me a short break down on this.... i have read on this for a bit but i need a little human language...

    thanks

    erik

    http://www.ConstructionSuperCenter.Com/SoftWare/Help/Sql-2005/Clustered-Index/Clustered-Index.png

    Dam again!

  • Hello!

    What is actually your question? Is it why the StartDate field is part of the PK?

    What do you mean by a 'go between' table?

    Regards,

    Hanslindgren

  • Is a go between table not the table that seperates the many to many relationship?

    I need a summery about that relationship that i posted please..

     

    erik

    Dam again!

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

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