Hi, We are designing a data warehouse. DB size is estimated to be about 250 to 300 GB. There are 6 fact tables, each has 20 to 25 millions rows. The largest fact table has 120 millions rows. There are 30 dimension tables, their size are negligible. OLAP cubes are processed using MS Analysis Services. We use SQL2K Enterprise, Cluster 2 nodes Active/Active, SAN, 4 CPUs servers, 4 GB RAM. The OLAP cubes are partitioned by month, the underlying fact table is not partitioned. We are exploring the idea of applying partitioned view. I have read the documentation and posts from this forum and google regarding partitioned view. I would greatly appreciate if you can help me to complete my review with your practical experiences. 1. Is there any "critical" DB size or rows count from which we should start considering partitioned view? 2. Were you happy/unhappy after having applied the partitioned view? What was the most significant benefits? 3. Is there any challenge (or traps) in maintaining a PV that a novice should particularly pay attention to? 4. For the size of our DW, is there any potential risk if we DON'T apply PV? Thanks you very much in advance for any help.