Privet wsem!!!
U menja takaja problema:
Est' tabliza:
-- Create table
create table XIMM
(
MM_ID NUMBER(12) not null,
MM_IDNAME VARCHAR2(100) not null,
MM_TYPE NUMBER(4) default 0 not null,
MM_HOST VARCHAR2(24) default 'localhost' not null,
MM_DIR VARCHAR2(200) not null,
MM_NAME VARCHAR2(100) not null,
MM_KEYIDX NUMBER(8) default 1,
MM_FILEDATE DATE default SYSDATE not null,
MM_FILEFORMAT VARCHAR2(6),
MM_FILESTAT CHAR(1),
MM_INSDATE DATE default SYSDATE,
MM_MODDATE DATE default SYSDATE,
MM_USER VARCHAR2(30) default USER,
MM_SIZE NUMBER(12) default 0,
MM_SUPPLIER VARCHAR2(24)
)
tablespace MM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 23920K
next 1M
minextents 1
maxextents 249
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table XIMM
add constraint XIMM_P1 primary key (MM_ID)
using index
tablespace MMIDX
pctfree 5
initrans 2
maxtrans 255
storage
(
initial 3620K
next 2304K
minextents 1
maxextents 249
pctincrease 50
);
alter table XIMM
add constraint XIMM_U1 unique (MM_HOST,MM_DIR,MM_NAME,MM_KEYIDX)
using index
tablespace MMIDX
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 25820K
next 13124K
minextents 1
maxextents 249
pctincrease 50
);
alter table XIMM
add constraint XIMM_R1 foreign key (MM_ID)
references MMID (MM_ID) on delete cascade;

Delaju sapros:
SELECT mm_id, mm_dir FROM XIMM
WHERE mm_idname = 'datname'
AND SUBSTR(mm_dir, INSTR(mm_dir, '\', -1) + 1) = UPPER(RTRIM('rol_nr', ' '));

Po mere sapolnenija tablizy sil'no uwelichiwaetsja wremja wypolnenijy saprosa (nachinaja so 150000 sapisey w XIMM).


Podskagite pogaluysta, chto mogno sdelat', chtoby sapros wypolnjalsja bystree.
Ja rabotaju na Oracle 8.1.6.0.0 pod Win 2000 Server.

Saranee spasibo!

Spasibo, poprobuju!!