On 1 May 2005 11:01:15 -0700, "Marcus" <to*******@yahoo.ca> wrote:
Speed of execution will be the same: the query analyzer parses both
statements to the same base sql.
Speed of implementation my be faster with option 2, if you choose
wisely, don't change your mind too often, and the db design is
relatively frozen.
-Tom.
I am wondering which method is better to use for a query.
1) For each query set up the necessary tables relationships in design
view, and extract the columns you want.
Ex:
a)query1 may have this table relationship:
table1-->table2-->table3-->table4-->table5
b)query2 may have this table relationship:
table1-->table2-->table3-->table6-->table7
b)query3 may have this table relationship:
table1-->table3-->table8-->table9-->table10
2) Create 2 or 3 queries as your base queries. For all other queries,
in their desgin view, create a relationship with the 2 or 3 base
queries. Then pull the necessary columns you want.
Ex:
a) query3 may have this relationship:
query1--->query2
b) query4 may have this relationship:
query1--->query3
Is option 2 redundant, or is it faster?
Marcus
*******