Re: That does It has more advantage?

Use a serial as primary key with no doubt, and the composed key as secondary one. If you need to link other child tables to that one, you will thanks God the serial. Byte byte! -- Mario R. Canto mcanto@intec.unl.edu.ar mcanto@intec.arcride.edu.ar http://www.intec.unl.edu.ar/~mcanto fhuezo@mh.gob.sv wrote: > > Hi everybody. > > I have a discussion about of what is more convenient. To use a table with 12 > fields like primary key or to use 12 fields like alternate key and to add a > serial field. > > The table could use into a the OLTP. > > That does sadvantage and disadvantage has one versus other? > Or is more recommendable that to check the data base design? > > Please, send me yours comment. > > Thank you. > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member For