I have table that is more or less as follows:
table Sample ( location bigint, device bigint, timestamp datetime, type bigint, value bigint, )
For performance reasons we also have one mighty index with same columns in identical order, except that
value is included rather than used in index.
This works as expected, except that AFAIU data is kept twice in database - once in the table and once in an index.
Question: is there some way to, conceptually, keep data only in the index? I believe that would require keeping table organized in the same way index is organized, effectively removing need for the index. I tried to create composed primary key that would emulate aforementioned index, but it boiled down to automatic creation of identical index.