I was under the impression that primary index is the same as clustered index i.e. the order in the index matches the physical order 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: > [EMAIL PROTECTED] writes: > > > What is the difference between a primary and a secondary index? > > None, neither exists. All indexes are just indexes. > > -- > Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
