Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Indexing and OLAP Cubes
- Thread starter Anbarasan
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
Yes and No. I have found that the answer really depends. Indexing may help if you are 1) filtering a subset of the fact table, or 2) using a non optimized schema where you are joining to all of the fact tables. One case where indexing won't help is if you are loading the entire fact table and the cube is properly optimized using keys. If this is the case then indexing won't help much because the cube is not joining to the dimension tables when it is loading the data.
When I was at ProClarity they swore that indexing didn't help a bit. Microsoft says that you should index. I say it depends.
dshroyer@obs3.com
OLAP Business Solutions
When I was at ProClarity they swore that indexing didn't help a bit. Microsoft says that you should index. I say it depends.
dshroyer@obs3.com
OLAP Business Solutions
- Status