Is a nonclustered index on a column with all other columns included almost like a clustered index on a different column? Will it actually duplicate the full Table?
Normally you might not need to do that because looking up the rows might be less costly than duplicating data but I am asking from a theoretical perspective.
I use the following database systems
Oracle. Would it depend on different databases?