4 ms·
> to influence the organization of records on disk so that the most common queries will require very few seeks might be revealing my lack of knowledge here but
by tjpick 16y ago
> to influence the organization of records on disk so that the most common queries will require very few seeks
might be revealing my lack of knowledge here but what tools/apis etc does one use when they want to work at this level? It seems like a good thing to do but I'd have no idea how to go about it. Enlightenment appreciated.
- JoachimSchipper 16y agoSQL has a CLUSTER command, for instance. See e.g. http://www.postgresql.org/docs/8.4/interactive/sql-cluster.html http://www.postgresql.org/docs/8.4/interactive/sql-cluster.h....
- tjpick 16y agoahhh, thanks.