I was under the impression that primary index is the same as clustered index i.e. the order in the index matches the
physicalorder the records are stored on disk thus making it better when doing sequential accesses.
I assume that this is exactly the use of the CLUSTER command, to actually make a primary index. T/F?
TIA,
thalis
On Sun, 17 Jun 2001, Peter Eisentraut wrote:
> zilch@home.se writes:
>
> > What is the difference between a primary and a secondary index?
>
> None, neither exists. All indexes are just indexes.
>
> --
> Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>