| From: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
|---|---|
| To: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
| Subject: | large type table |
| Date: | 2003-09-30 19:20:06 |
| Message-ID: | 3F79D766.1020100@virginia.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I am creating a database that will have about 12 type tables associated
with it. Someone has suggested making one type table that would have a
field that identifies which types go with each other (like separating
them into individual tables).
Is this a wise idea? It seems to me that it could cause duplication of
data in some query results. Is it more efficient to limit the number of
joins in this manner?
Thanks
Jodi
--
/_______________________________
//Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu <mailto:jkanter(at)virginia(dot)edu>/
/ /
/ /
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaetano Mendola | 2003-09-30 23:41:39 | News group |
| Previous Message | Anna Kanevsky | 2003-09-30 15:28:33 | Delete accident |