This content has been marked as final. Show 2 replies
1 person found this helpful
...so that the application doesn't have to go into the PL/SQL tables every time?I'm not sure what you mean by this. If you have a small table that will contain often-queried lookup data, then creating the table with the CACHE clause and no index is possible. When the table is first queried, it will perform a full-table scan into the DB Block buffer cache. The CACHE clause changes the default behavior such that the blocks don't get aged out quickly. Subsequent queries will pull the data from memory rather than disk so long as it remains cached.
Oracle is a relational database and most, if not all the of Apex engine is stored within the database. This means that for anything you are likely to be doing, you are not going to get faster access to data than simply putting it in a table and then fetching it from there. If you find that data is not being pulled from the database as quickly as you require then the most likey course of action to follow will be a database/query tuning exercise.