just a theoretical question: I have tested the max function on a table with two fields and exactly 100.000 rows. The tested field was the primary key. The max function was very fast (less, than 1 ms). My table, thereat I have made the test, has 37 fields.
Does the number of fields affect the speed of the max function? The field in the max function is the same (same type of the tested table and primary key).
View Complete Post