Hello everyone,
I wonder is there any pre defined sequence in Access when it executes
queries and views.
For example, is there any difference in efficiency of the following
two queries?
1. SELECT * FROM table1, table2
WHERE table1.date=tab le2.date
AND table1.name like "%A%"
2. SELECT * FROM table1, table2
WHERE table1.name like "%A%"
AND table1.date=tab le2.date
table1 is a huge table with millions of records. So if Access can
filter it with "table1.nam e like "%A%"" first, the join part will be
greatly speeded up.
I wonder is there any pre defined sequence in Access when it executes
queries and views.
For example, is there any difference in efficiency of the following
two queries?
1. SELECT * FROM table1, table2
WHERE table1.date=tab le2.date
AND table1.name like "%A%"
2. SELECT * FROM table1, table2
WHERE table1.name like "%A%"
AND table1.date=tab le2.date
table1 is a huge table with millions of records. So if Access can
filter it with "table1.nam e like "%A%"" first, the join part will be
greatly speeded up.