Displaying 2 results from an estimated 2 matches for "ctx_ddl".
Did you mean:
ctx_addr
2004 Nov 22
3
Mode context extremely poor performance.
...VARCHAR2(4000)
ZERANK NUMBER
The index:
----------
create index SNAP.CTX_PROFIL_MATCH_${ROLE}_${SEX}_01
on SNAP.vwmt_PROFIL_match_${ROLE}_${SEX} (RECH_CRITERES)
indextype is ctxsys.context PARAMETERS ('MEMORY 50M STORAGE
text_storage')
/
with:
-----
BEGIN ctx_ddl.create_preference('SYS.TEXT_STORAGE',
'BASIC_STORAGE'); ctx_ddl.set_attribute('SYS.TEXT_STORAGE',
'I_INDEX_CLAUSE',
'pctfree 0 tablespace TBS_SNAP_INDEX');
ctx_ddl.set_attribute('SYS.TEXT_STORAGE', 'I_ROWID_INDEX_CLAUSE',
'pct...
2004 Nov 22
3
Mode context extremely poor performance.
...VARCHAR2(4000)
ZERANK NUMBER
The index:
----------
create index SNAP.CTX_PROFIL_MATCH_${ROLE}_${SEX}_01
on SNAP.vwmt_PROFIL_match_${ROLE}_${SEX} (RECH_CRITERES)
indextype is ctxsys.context PARAMETERS ('MEMORY 50M STORAGE
text_storage')
/
with:
-----
BEGIN ctx_ddl.create_preference('SYS.TEXT_STORAGE',
'BASIC_STORAGE'); ctx_ddl.set_attribute('SYS.TEXT_STORAGE',
'I_INDEX_CLAUSE',
'pctfree 0 tablespace TBS_SNAP_INDEX');
ctx_ddl.set_attribute('SYS.TEXT_STORAGE', 'I_ROWID_INDEX_CLAUSE',
'pct...