SELECT COUNT(1) NEARLINE_FIELS FROM DAVA_DOC,DAVA_DOC_STORE,DAVA_TAPELIB_STATUS WHEREDAVA_TAPELIB_STATUS.TAPE_BARCODE=DAVA_DOC_STORE.TAPE_ID AND DAVA_DOC.ID=DAVA_DOC_STORE.DOC_ID ANDDAVA_DOC_STORE.FLAGS=2 ANDDAVA_DOC.FLAGS=2 AND(DAVA_DOC.GROUP_ID = '...
显示全部SELECT COUNT(1) NEARLINE_FIELS FROM DAVA_DOC,DAVA_DOC_STORE,DAVA_TAPELIB_STATUS WHERE
DAVA_TAPELIB_STATUS.TAPE_BARCODE=DAVA_DOC_STORE.TAPE_ID AND
DAVA_DOC.ID=DAVA_DOC_STORE.DOC_ID AND
DAVA_DOC_STORE.FLAGS=2 AND
DAVA_DOC.FLAGS=2 AND
(DAVA_DOC.GROUP_ID = 'eb8a21c5-eaaa-4e24-a599-1aa241996377')@
这样的涉及到多个表的查询,会不会用到索引?
还有where后边的条件顺序 有讲究嘛?
收起