Depending on your DBMS, I recommend doing some searches within the vendor's devnet areas looking for hints on performance tuning. Also check out the InnerCore at www.coreintegration.com for ideas and/or post your query. But get specific on the installation. What DBMS, what version, size of the dimension tables, what is the query tool, etc.
Dig Deeper on Oracle and SQL
Related Q&A from Mike Lampa
When trying to design a data warehouse, we often try to model the database on the operational data model. Are there any guidelines in trying to ...continue reading
What is a surrogate key in a table?continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.