You can
view the outlines and related hints via the USER_OUTLINES and USER_OUTLINE_HINTS views.
To start creating hints for all queries, create custom categories of outlines and use the category
name as a value of the CREATE_STORED_OUTLINES parameter in the database initialization file,
as shown here:
CREATE_STORED_OUTLINES = development
In this example, outlines will be stored for queries within the DEVELOPMENT category.
You must have the CREATE ANY OUTLINE system privilege in order to create an outline. Use
the create outline command to create an outline for a query, as shown in the following listing:
?–
?–
?–
?–
Chapter 5: Developing and Implementing Applications 141
create outline YTD_SALES
for category DEVELOPMENT
on
select Year_to_Date_Sales
from SALES
where region = 'SOUTH'
and period = 1;
NOTE
If you do not specify a name for your outline, the outline will be given
a system-generated name.
If you have set CREATE_STORED_OUTLINES to a category name in your initialization file,
Oracle will create stored outlines for your queries; using the create outline command gives you
more control over the outlines that are created. Unless you??™re sure that you want to create stored
outlines for the entire database, set this parameter at the session level instead of the system level.
NOTE
You can create outlines for DML commands and for create table as
select commands.
Once an outline has been created, you can alter it.
Pages:
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261