Query Performance Clarification

[shabar]

Hi All

If run below query does it effect to performance or can I straightway use the query(T2) to link with other tables and get results


Here T2 is a saved query

SELECT * INTO T1 FROM T2

What the difference?


Appreciate your clarification


Cheers

Shabar

[June7]

I don't understand what you want. That looks almost like a make table query but don't think syntax is correct. Why duplicate records from T2 into T1?

Yes, queries can be used in queries.

[shabar]

Hi June7

Sorry for the confusion

What I meant was, Here T1 is a query where I extracted several columns from different tables. Assume saved query work as a View in access

Select T2.* INTO [T1] from T2

If I want to join above T2 with some other table and get some results, performance wise what would be the best option.

- Use the saved query(T2) straightway OR
- create a new table (T1) with that data and then run the wanted query


Hope this will clear to some extent


Cheers

Shabar

[June7]

If T2 is a simple SELECT query I don't think performance would be much different if saved to a table. You could test this out. Try the table approach and try using T2 in another query.