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