Use Materialized Views
You can use materialized views to divide the types of operations users perform against your tables.
When you create a materialized view, you can direct users to query the materialized view directly
or you can rely on Oracle??™s query rewrite capability to redirect queries to the materialized view.
As a result, you will have two copies of the data??”one that services the input of new transactional
data, and a second (the materialized view) that services queries. As a result, you can take one of
them offline for maintenance without affecting the availability of the other. Also, the materialized
view can pre-join tables and pre-generate aggregations so that user queries perform as little work
as possible.
Use Parallelism
Almost every major operation can be parallelized??”including queries, inserts, object creations,
and data loads. The parallel options allow you to involve multiple processors in the execution of
a single command, effectively dividing the command into multiple smaller coordinated commands.
As a result, the command may perform better. You can specify a degree of parallelism at the object
level and can override it via hints in your queries.
Test Correctly
In most development methodologies, application testing has multiple phases, including module
testing, full system testing, and performance stress testing. Many times, the full system test and
performance stress test are not performed adequately due to time constraints as the application
nears its delivery deadline.
Pages:
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241