clustered index and non clustered index
hi frineds ihave qqustion about index
in sqlserver table has 1 clustered index and 280(average) non clustered index.
sqlserver hold clustered index and data on same location. so clustered index ordering data phisicaly
but sqlserver hold non clustered index on another file and dont order data directly.
how oracle index do this? for example i have 3 table index. how they work?is oracle has this clustered index and non clustrered index ?