I am unclear as to what is meant by the following warning messages that I have always received:
<!-- 115 /crosshairs Field PATN_WKU- non-existent -->
<!-- 200 /crosshairs Can't handle ORDER BY with compound index -->
Here is the query:
select id, PATN_TTL, PATN_WKU from PATN where PATN_ISD between '20110103' and '20110712' and (ABST_PAx like 'fiber coupler w/4') order by PATN_ISD DESC, PATN_WKU DESC
I have two MM indexes on ABST_PAx, created with the following statements:
create METAMORPH INVERTED index PATN_ABST_PAx_MI on PATN(ABST_PAx,PATN_ISD)
create METAMORPH INVERTED index PATN_ABST_PAx_D_MI on PATN(ABST_PAx,PATN_ISD DESC)
I also have two standard indexes each on PATN_ISD and PATN_WKU, created with these statements:
CREATE INDEX PATN_ISD_D_I on PATN(PATN_ISD DESC)
CREATE INDEX PATN_ISD_I on PATN(PATN_ISD)
CREATE INDEX PATN_WKU_D_I on PATN(PATN_WKU DESC)
CREATE INDEX PATN_WKU_I on PATN(PATN_WKU)
And yet the warning persists. I'm not sure what I'm missing here.
Thanks.
<!-- 115 /crosshairs Field PATN_WKU- non-existent -->
<!-- 200 /crosshairs Can't handle ORDER BY with compound index -->
Here is the query:
select id, PATN_TTL, PATN_WKU from PATN where PATN_ISD between '20110103' and '20110712' and (ABST_PAx like 'fiber coupler w/4') order by PATN_ISD DESC, PATN_WKU DESC
I have two MM indexes on ABST_PAx, created with the following statements:
create METAMORPH INVERTED index PATN_ABST_PAx_MI on PATN(ABST_PAx,PATN_ISD)
create METAMORPH INVERTED index PATN_ABST_PAx_D_MI on PATN(ABST_PAx,PATN_ISD DESC)
I also have two standard indexes each on PATN_ISD and PATN_WKU, created with these statements:
CREATE INDEX PATN_ISD_D_I on PATN(PATN_ISD DESC)
CREATE INDEX PATN_ISD_I on PATN(PATN_ISD)
CREATE INDEX PATN_WKU_D_I on PATN(PATN_WKU DESC)
CREATE INDEX PATN_WKU_I on PATN(PATN_WKU)
And yet the warning persists. I'm not sure what I'm missing here.
Thanks.