A next logical step after index-only scans?

Started by Mike Christensenover 13 years ago1 messagesgeneral
Jump to latest
#1Mike Christensen
mike@kitchenpc.com

Now that 9.2 supports index-only scans, I'm curious what possibilities
this opens up in the future.

It seems to me that the next logical step is to allow a user to put
all columns into the index, at which point you would no longer even
need the heap table. Oracle calls this "index-organized tables", and
this offers a lot of benefits for tables with only one index.

Any thoughts on this, or is it on the road map? Thanks!

Mike