If you are repeatedly querying tables on non-key fields you can improve query speeds
by implementing indexes on those fields...
For instance, if you had a personnel table with the following fields: id, lastname,
firstname, etc Where id was an auto-increment,primary key you could index the
Hi,
I have some huge databases generated from text file of a dictionary.
I would like to know if I make a query based on a field which was not metion as a
key
at the creation of the table. Is the speed of the query affected by the size of the
records and by the number of fields a rec
