Does Database Partition and Index,table Partiton are two different things?

  • Does Database Partition and Index,table Partiton are two different things?

    Thanks

  • What do you mean by 'database partition'? It's not a feature on its own, it usually refers to some mechanism of partitioning a table

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thanks

    Thanks

  • There is no any term like Database Partitioning ,the correct term is Table partitioning and Index partitioning

    http://msdn.microsoft.com/en-us/library/ms345146(v=sql.90).aspx

    visit on the link for further clarification

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

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

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