SQL CLUSTERED INDEX, CLUSTERED INDEX vs PRIMARY KEY, HEAP Table vs CLUSTERED Table Scan
SQL CLUSTERED INDEX, CLUSTERED INDEX vs PRIMARY KEY, HEAP vs CLUSTERED Table, Table Scan vs CLUSTERED INDEX Scan, SQL Index Page Clustered Index, SQL Heap Table, Table Scan vs INDEX Scan, Creating CLUSTERED INDEX on a View, 8KB Page, IAM Page, Index Page, Data Page Agenda: Q01. What is Heap in SQL Q02. What is the difference between Table Scan and CLUSTERED INDEX Scan Q03. What is CLUSTERED INDEX in SQL How can you create a CLUSTERED INDEX Q04. How many CLUSTERED INDEX can you have on a table Q05. On what basis the data is physically stored in the SQL, based on PRIMARY KEY or CLUSTERED INDEX Q06. Does a CLUSTERED INDEX always UNIQUE Q07. Does CLUSTERED INDEX always contain only the UNIQUE value in that column Q08. Does it mandatory for the CLUSTERED INDEX to be unique Q09. What type of index is created by the PRIMARY KEY in SQL Q10. Can you create a CLUSTERED INDEX on the table which has a PRIMARY KEY Q11. Can you create a PRIMARY
|
|