Hi, I have some queries doing a SCAN. I identify then and I create a index.
For example: explain SELECT PSV.PSV_COD , PSV.PSV_APEL , PSV.PSV_TRAT , PSV.PSV_TIPO FROM PSV WHERE ( PSV.PSV_TIPO<> 'I' ) ORDER BY PSV.PSV_APEL ASC Results: DBA PSV TABLE SCAN 1019 DBA RESULT IS NOT COPIED , COSTVALUE IS 1019 I created a index on PSV.PSV_TIPO <> 'I' but the query is scanning the table again. After the index xreatino I have to do some other thing? Best regards, -- Daniel Castro - דניאל MSN: [EMAIL PROTECTED] Skype: danielti2005 ICQ : 316727989 Jabber: danielti Linux User: 387864 AOL User: Danielti2005 Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli Deo Gloria
