does order of fields in query either speed up or slow down the process esp. if...

[russi]

Hi. Was wondering if the order of fields in a query would impact the speed of processing, esp. if the query is on the front end of a split database?

Thanks.

Russ

 

[pcs]

while i haven't tested specifically for it, i don't think the order of the fields in a stored query makes any difference...

making sure that you have indexes set up in your table design for appropriate fields, does, however, have a major impact on speed.

hth,
al

 

[glynch]

Only if your doing some kind of grouping or using functions or expressions in your fields.