Precomputed Result Sets and sp_help

sp_help displays information about precomputed result set objects in the Object_type column. The SAP ASE server treats precomputed result set objects internally as user tables. When you issue sp_help with a precomputed result set as the objectname, it reports all the relevant details about columns, partitions, keys, indexes, and so on, similar to when you run sp_help against a user table.

Additionally, the Object_Status column returns the following for precomputed result sets:
  • For user tables – returns precomputed result set defined in the Object_Status column if any precomputed result set objects are defined on the user table

  • For precomputed result set objects – returns the following in the Object_Status column for:
    1. The refresh mode – immediate or manual

    2. The precomputed result set state – enabled or disabled

    3. The query rewrite state – enable for QRW or disabled for QRW