I`M WORKING WITH ORACLE8 FOR NT.
I HAVE CREATED ONE TABLE LIKE THIS
ID NUMBER(9)
EMPRESA NUMBER(9)
CODIGO VARCHAR2(10)
DESCRIPCION VARCHAR2(40)
...
MORE FIELDS...
...
INDEX
INDEX_001 FIELDS(EMPRESA,CODIGO)
INDEX_002 FIELDS(EMPRESA,DESCRIPCION)
WHEN I HAVE A SELECT LIKE THIS:
SELECT * FROM ARTICULOS
WHERE EMPRESA=1
ORDER BY DESCRIPCION
IT TAKES A LOT OF TIME TO GIVE ME THE FIRST ROWS.
AND IF I DO:
SELECT * FROM ARTICULOS
WHERE EMPRESA=1
IT TAKES A FEW TIME.
AND IF I DROP INDEXES IT TAKE THE SAME TIME OR LESS.
WHAT HAPPEND, PLEASE??
Received on Sat Sep 16 2000 - 07:33:40 CDT
