views:

29

answers:

1

Can we define a nonclustered index without defining the clustered index on a table?

+1  A: 

Yes, we can.

In this case, the RIDs will serve instead of the clustered keys as record pointers.

Quassnoi
can you define any scenario?
Azhar
@Azhar: scenario of what?
Quassnoi