Can I prevent temporary views from being deleted when a performance analysis is being carried out?
Temporary views that no longer exist after the SQL statement is processed are also partially created in the BW environment and therefore cannot be used for a performance analysis (EXPLAIN). You can prevent temporary views from being deleted by making an entry in the RSADMIN table. See Note 373738. As an alternative to the procedure described in Note 373738, you can also create a SQL trace (transaction ST05). This SQL trace contains the CREATE view statement of the temporary views. You can create this view in SQL Studio and then execute the Explain on the corresponding SELECT.
