I used to find the code as follows:
SELECT ROWIDS,ID,NGAYTAO,NGAYXUATBAN,CHUYENMUC,FULLPATH,NGONNGU,NOIDUNG,TIEUDE
,(SELECT CTX_DOC.SNIPPET('SEARCH_DNICT_MOTA_IDX',ROWIDS,:tukhoa) FROM DUAL) || '..' ||
(SELECT CTX_DOC.SNIPPET('SEARCH_DNICT_NOIDUNG_IDX',ROWIDS,:tukhoa) FROM DUAL) || '..' ||
(SELECT CTX_DOC.SNIPPET('SEARCH_DNICT_TTHC1_IDX',ROWIDS,:tukhoa) FROM DUAL) || '..' ||
(SELECT CTX_DOC.SNIPPET('SEARCH_DNICT_TTHC2_IDX',ROWIDS,:tukhoa) FROM DUAL) || '..' ||
(SELECT CTX_DOC.SNIPPET('SEARCH_DNICT_TTHC3_IDX',ROWIDS,:tukhoa) FROM DUAL) || '..' ||
(SELECT CTX_DOC.SNIPPET('SEARCH_DNICT_TTHC4_IDX',ROWIDS,:tukhoa) FROM DUAL) || '..' MOTA
FROM SEARCH_DNICT
WHERE (CONTAINS(SEARCH_DNICT.TIEUDE,:tukhoa,1)>0
OR CONTAINS(SEARCH_DNICT.MOTA,:tukhoa,2)>0
OR CONTAINS(SEARCH_DNICT.NOIDUNG,:tukhoa,3)>0
OR CONTAINS(SEARCH_DNICT.TTHC1,:tukhoa,4)>0
OR CONTAINS(SEARCH_DNICT.TTHC2,:tukhoa,5)>0
OR CONTAINS(SEARCH_DNICT.TTHC3,:tukhoa,6)>0
OR CONTAINS(SEARCH_DNICT.TTHC4,:tukhoa,7)>0)
- when I following query return 50 documents it takes 10.969 seconds load just for one use. Now my database is not only very little data
- I find if such search is too slow, I have studied but have not found a way to accelerate your returns faster results like?
- I want to improve performance query is how?
- I hope people will help me solve
Thanks every body!