Delete cube request - before or after index creation?
a quick question. I plan to delete for one cube requests that are older than 3 days (cube only hosts short term reporting). Now I wonder if this should be done aftter the new load but before the index is created or after the index is created.
I guess it is after the index is created otherwise it would take longer to find the requests that should be deleted. The index will be slighly degenerated due to the deletion but should be only marginal.
I am right or wrong?
Thanks for all replies in advance,
M Tibollo replied
as far as i know (and remember) , SAP advices to first build indexes and then delete the overlapping requests. I'm sure that if you look on the forum you'll find some proper SAP documentation
here you are:
Edited by: M Tibollo on May 25, 2011 11:02 AM