正規化

上課影片(2)

DB-K1a-Day6-1019(2)-key-index-正規化

http://cc.cust.edu.tw/~ccchen/doc/db_04.pdf

Clustered vs. Nonclustered Index Structures in SQL Server

上課影片(1)

DB-K1a-Day6-1019-key-index

Index(Clustered, Non-Clustered)

• are used to improve the speed of database operations
• are quite similar to book indexes
• allows you to go straight to the different topics
• Without indexes you would have to search the whole table
• A clustered index is an index which defines the physical order
• By default a clustered index is created on a primary key column.

When to Use Clustered or Non-Clustered Indexes in SQL Server By: Ben Richardson