Закрыть

Hey there! boomer4you is using Stickr.

Stickr is a free service that helps you comment and share anything on the Web, follow others comments and leave notes for yourself and your friends - on any website you want!
Join Stickr today to start following boomer4you's stickers and comment websites on your own.

Get started

boomer4you


Rating: 1.00
perform worse than clustered indexes on ranged searches where the result set is large, since each result could cost an additional I/O-operation to get the actual data record

search for b># using non-clustered index on b

Ctrl + Enter

A clustered index sorts and stores the data rows in the table based on the index key values. Therefore only one clustered index can be created on each table because the data rows themselves can only be sorted in one order.

Q1 a) Explain why it is not possible to have more than one clustered index per relation

Ctrl + Enter

Загрузка...