Overview of clustered and nonclustered index - not DB specific (as I understand):
Clustered Index: The physical order of data. As a result, a table can only have one clustered index.
Nonclustered Index: One or more nonclustered indexes can be configured per table. Does not directly impact the organization of the data page.
Is there a difference between how Microsoft SQL Server and Oracle 'manage' clustered and nonclustered indexes? Or is it the same across the DBS?
Any guidance would be great!
No comments:
Post a Comment