Forum Discussion
Query optimization
I have a transaction table with about a half of a million of records. I will need about 5-6 tables based on that data. I am afraid that creating a query for each table won't be as efficient as having...
Do you plan to create a star schema of tables from your original table? A good idea if so. You can create your original query, then right click on it and choose Reference for each of your new tables, so you are hitting your source only once. You can then uncheck "Enable Load" on your original query. Also make sure you uncheck the box in the options to "Enable Parallel Loading of Tables". You'll want that turned off so that each query doesn't repeat the original query.
Pat
mahoneypat Will data be refreshed if the original query is not loaded nymore?