Which is the best structure ...

Thierry Nauze huancaya at wanadoo.fr
Sat May 8 17:33:40 CDT 2004


Which is the best structure, knowing that less than 25 % of fields 
'texte' will not be empty.

First case:
	TABLE   sources
	id		UMedium
	idX		UMedium
	idY   		UMedium
	texte 	VarChar(1016,'French')


Second case:
	TABLE   sources
	id		UMedium
	idX		UMedium
	idY   		UMedium
	IDTexte 	UMEDIUM

TABLE  textes
	idTexte	UMedium
	texte 	VarChar(1016,'French')

Thanks

--
Thierry Nauze			Saint-Denis de la Réunion



More information about the Valentina mailing list