can you show us all the indexes on w_entity_document_test_new and the actual execution plan?
did your covering index include all teh columns in the query?
ie
CREATE INDEX IX_tezt
ON w_entity_document_test_new (ENTITY_ID,
ENTITY_TYP_CD,
DOC_TYP_CD,
STS_CD)
INCLUDE( NM,
FORMAT,
INTEGRITY,
TEXT,
REFERENCE,
ALG,
LANG,
COMP,
CHARSET,
PAR_ID,
UPDTSEQ,
CONF )
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!