Displaying 2 results from an estimated 2 matches for "text_storag".
Did you mean:
text_storage
2004 Nov 22
3
Mode context extremely poor performance.
...NUMBER
RECH_CRITERES 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', '...
2004 Nov 22
3
Mode context extremely poor performance.
...NUMBER
RECH_CRITERES 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', '...