Simon Riggs wrote:
> I'd like to see something along the lines of demand-created optional
> indexes, that we reclaim space/maintenance overhead on according to
> some cache management scheme. More space you have, the more of the
> important ones hang around. The rough same idea applies to
> materialised views.
+10; this sort of demand-driven optimization could be the database
equivalent of Java's HotSpot (which accomplished the amazing task of making
Java kinda fastish sometimes).
Jay