Search Postgresql Archives

Is the primary key constraint also an index?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



If I have a primary key constraint defined in the database do I also
need to create an index on that field for fast lookup?

The documentation on the web seems to imply that the contraint is not
an index. Is that right?

What the difference between creating a unique, not null index and
setting a primary key?

Thanks.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux