On Monday 15 April 2002 05:15, Christopher Kings-Lynne wrote: > > On Monday 15 April 2002 03:53, Christopher Kings-Lynne wrote: > > > BTW, instead of: > > > > > > CREATE UNIQUE INDEX bigone_pkey ON bigone (rec_no); > > > > > > do: > > > > > > ALTER TABLE bigone ADD PRIMARY KEY(rec_no); > > > > I am sorry, could you please elaborate more on the difference? > > They have the same _effect_, it's just that the first sytnax does not mark > the index as the _primary_ index on the relation.
Yes, I know. I mean how does this affect performance? How this can change planner decision? Does it have any effect except cosmetical one? -- Denis ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
