>CLEAR >SET DELETED ON >CREATE CURSOR Test (TBL_ID_FLD C(20),TBL_INT_FLD int) >INDEX ON TBL_ID_FLD + BINTOC(TBL_INT_FLD) FOR NOT DELETED() TAG Test >SYS(3054,12) >SELECT * FROM Test; >WHERE TBL_ID_FLD + BINTOC(TBL_INT_FLD) LIKE 'asdasdasda%' INTO CURSOR crsTest && Full >? >SELECT * FROM Test; >WHERE TBL_ID_FLD + BINTOC(TBL_INT_FLD) = 'asdasdasda' INTO CURSOR crsTest && Full >SYS(3054,12) >You see, in my case most queries would be like this:
SELECT * FROM Test; WHERE TBL_ID_FLD = 'adadfasd' and TBL_INT_FLD = 2 INTO CURSOR crsTest && Partial SYS(3054,12)Does Partial mean that the Rushmore will only use the TBL_ID_FLD portion of the index tag?