Question Select Query or Make Table query

[lordrom]

I am starting to build a database and have to decide whether to use select queries or make table queries.

Can anyone advise me on when it is best to use either type of query please? Are there guidelines on which is best in different circumstances?

 

[pbaldy]

I would use select queries unless there was a really good reason to use a make table query.

 

[plog]

Select queries.

The only cases where I have used MakeTable queries is when I was running multiple aggregate queries that shared a common sub-query that itself was complex and ran off tables that were enormous. Since that sub-query took so long to run and was being run multiple times, I had it run once to make a table then ran my aggregate queries using that table instead of the sub-query. It went from taking 1 hour to run to running in 10 minutes.