Re: cluster index on a table

Scara Maccai <m_lists@yahoo.it> wrote:

> What am I doing wrong?

> [function which uses INSERT/UPDATE/DELETE statements to try to force
> order of rows in heap]

You seem to be assuming that the rows will be in the table in the
sequence of your inserts.  You might be better off with a CLUSTER on
some index.  (There are a few other options, like TRUNCATE / INSERT or
SELECT INTO / DROP TABLE / ALTER TABLE RENAME -- but CLUSTER is
probably the safest, easiest way to go.)

-Kevin