Re: How to handle primary and foreign key indexes in Informix?

nslard wrote: > > On the topic of indices ( Primary and FOreign keys ) which data field > should we select as the primary key. Does selecting a different field > slow down the programme execution? > If you are referring to which column, well that depends on your data model. This would obviously be the primary key field. If you are referring to what data type is best, integers are faster than chars. Tim