For example, a SQL query requiring 10,000 rows to be presented in sorted order will often use a b-tree index to avoid the very large sort required to deliver the data to the end user. Oracle ...

Oracle's answer to this dilemma is the materialized ... you create materialized views satisfying the largest number of SQL queries. For example, if you identify 20 queries commonly applied to ...

For this example you create a view descriptor, VLIB.ALLEMP, based on SYBASE data. The outer PROC SQL query retrieves data from the view descriptor; the subquery uses a Pass-Through query to retrieve ...