The following limits apply to SQL Views:
To minimize the impact of runaway transactions, use the inquiry schema user. You can also test new queries on smaller populations.
All views are created within the inquiry schema user as owner. Inquiry schema user is granted inquiry-only access over all tables and views, including those owned by deployment schema user.
Views are not created for the stn tables. Views are not provided for ROC17 tables.
The following constructs may significantly degrade performance:
Using ORDER BY clauses to achieve ordering in Profile Ordinate or Class Ordinate order (this order is automatic).
Using WHERE clauses with Non-Keyed Class or Event views, where the population of the Non-Keyed Class or Event Set is large, but few records meet the condition.
Using Keyed Class or Profile views with a WHERE clause including non-key items, or including lower-order keys without the higher-order keys.