Truncating a precomputed result set removes the data but retains the definition of the precomputed result set in the system table.
- In the Administration Console view, select .
- Click the Name field of the precomputed result set, then click the drop-down arrow
and select Truncate.
- From the Confirm Truncate window, select:
- Preview – to view the
SQL text of the precomputed result set you are truncating.
- Yes – to truncate the data in the precomputed result
set.
- No – to cancel the truncate.