Does anyone have any suggestions on how to improve the speed at which my queries run?
I am working with a table that contains over 500,000 records. I am running queries off of queries from the original table. In the queries, I am selecting records, doing group bys and even a union query.
When I try and run the final query, which is based on all of the previous queries, it is taking forever. Is it the number of records that is the issue, the types of queries that I am running or simply my computer? I have an IBM ThinkPad.
Thanks in advance for your help.
I am working with a table that contains over 500,000 records. I am running queries off of queries from the original table. In the queries, I am selecting records, doing group bys and even a union query.
When I try and run the final query, which is based on all of the previous queries, it is taking forever. Is it the number of records that is the issue, the types of queries that I am running or simply my computer? I have an IBM ThinkPad.
Thanks in advance for your help.