Anthony Mandic wrote:
> John Salvo wrote:
>
>>Performance and Tuning Guide
>>Chapter 8 - Indexing for Performance --> Choosing Indexes --> Index keys
>>and logical keys ( page 176 )
>>
>>"A common error is to create the clustered index for a table on the
>>primary key, even though it is never used for range queries or ordering
>>result sets."
>
>
> Its not really clear but its telling you to put the clustered index
> on the columns you would most frequently use for range queries or
> ordered result sets. That's where the clustered index is most
> effective. For a single keyed access or single row access, a non-
> clustered index is OK. Note that this only really applies to APL
> tables (since the concept of clustered isn't applicable to DOL
> tables).
>

Care to elaborate ?

Chapter 9, page 190 of Performance and Tuning Guide -- "Types on
Indexes" shows that clustered index are applicable to DOL tables as well.