|
About
Oracle dbms_expfil
If the index parameters are directly
assigned to an expression set (column
storing expressions), the PARAMETERS clause
in the CREATE INDEX statement cannot contain
the STOREATTRS or INDEXATTRS clauses. In
this case, the Expression Filter index is
always created, using the parameters
associated with the declared expression set.
To find the parameters associated with the
attribute set use the
dbms_expfil.index_parameters and
dbms_expfil.xpindex_parameters APIs and
the user_expfil_index_parameters
catalog view.
Expressions packages and procedures:
BEGIN
dbms_expfil.create_attribute_set(attr_set =>
'Boat4Sale');
dbms_expfil.add_elementary_attribute(
attr_set => 'Boat4Sale',
attr_name => 'Model',
attr_type => 'VARCHAR2(20)');
dbms_expfil.add_elementary_attribute(
attr_set => 'Boat4Sale',
attr_name => 'Year',
attr_type => 'NUMBER');
dbms_expfil.add_elementary_attribute(
attr_set => 'Boat4Sale',
attr_name => 'Price',
attr_type => 'NUMBER');
dbms_expfil.add_elementary_attribute(
attr_set => 'Boat4Sale',
attr_name => 'EngineHours',
attr_type => 'NUMBER');
dbms_expfil.add_elementary_attribute(
attr_set => 'Boat4Sale',
attr_name => 'Length',
attr_type => 'NUMBER');
END;
/
|
|
