| From: | Brian <signal(at)shreve(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | difference in INDEX's |
| Date: | 1998-07-04 23:54:08 |
| Message-ID: | Pine.LNX.3.96.980704185248.6836A-100000@mercury.shreve.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Is there a difference in doing:
foo int PRIMARY KEY
and
CREATE INDEX idx1 on table (foo);
does both do the same thing (create an index)? is one faster or preffered
over the other?
/-------------------------- signal(at)shreve(dot)net -----------------------------\
| Brian Feeny | USR TC Hubs | ShreveNet Inc. (318)222-2638 |
| Network Administrator | Perl, Linux | Web hosting, online stores, |
| ShreveNet Inc. | USR Pilot | Dial-Up 14.4-56k, ISDN & LANs |
| 89 CRX DX w/MPFI, lots of |-=*:Quake:*=-| http://www.shreve.net/ |
| mods/Homepage coming soon |LordSignal/SN| Quake server: 208.206.76.47 |
\-------------------------- 318-222-2638 x109 -----------------------------/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | The Hermit Hacker | 1998-07-05 03:00:01 | Weekly Posting: Mini-FAQ (Last Modified: Jun 7, 98) |
| Previous Message | The Web Administrator | 1998-07-04 18:40:56 | Re: [GENERAL] DBI/DBD-Pg/perl question |