SELECT Hon INDEX ON DTOS(DataVed)+BINTOC(Lev1)+BINTOC(Lev2)+BINTOC(Lev3) TAG HonVed m2 = DATE(2004,12,2) SYS(3054,11) SELECT hon.egn, dataved, lev1, lev2, lev3 FROM hon WHERE DTOS(DataVed)+BINTOC(lev1)+BINTOC(lev2)+BINTOC(lev3) LIKE DTOS(m2)+BINTOC(3)+BINTOC(334)+BINTOC(1) NOFILTER ** Here what SYS(3054) display Using index tag Honvedom to rushmore optimize table hon Rushmore optimization level for table hon: partial Rushmore optimization level for table homo: none Joining table hon and table homo using index tag Homo_egnMy question is WHY Rushmore optimization level for table hon: partial Partial?