Routing queries to cache tables

You can route queries to the materialized query table for the cache table or to data source by routing the queries to the nickname.

1. In the Control Center, expand the Cache Objects folder and the Cache Tables folder.
2. Right-click the appropriate cache table and click Properties.
3. Select the materialized query table and click Check Status.
4. Select where you want the queries to route the queries:
   • Select Route to the materialized query table. All queries for the data source are sent to the materialized query table. If the data in the materialized query table cannot satisfy the query, the query is then routed to the data source using the nickname.
   • Select Route to the nickname. All queries are sent to the data source by using the nickname. The materialized query table is changed to a regular database table. Replication to the materialized query table continues unless you disable caching.
5. To change the routing immediately, select the Remove all cached dynamic SQL statements check box. The dynamic SQL statements that are currently in the package cache are deleted.
6. Click OK.