+2I want to create a new super projection for a large fact table. To avoid having a bad impact for server resource, I want to resume the proccess to prepare for the projection nightly. Is it possible?
To prevent performance degradation, Is the only choice to use Refresh Resource Pool?
Thanks in advance,
+1I think your best bet would be to create a new table with your new projection(s) and incrementally load every night. Hopefully the table is partitioned so you can prevent some seek overhead.
+2Thank you!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
