Once a view or procedure's data is cached, it should be treated like a database table (unordered, unfiltered). When querying the cache table, if the results need to be ordered, a view should be created from the cached view or procedure to apply the ORDER BY. The ORDER BY clause is not preserved after caching. Cached data should be regarded as a materialized table, not as the view or procedure it was created from.