Oracle Text query with multiple contains performance [message #264520] |
Mon, 03 September 2007 11:20 |
Agus211
Messages: 39 Registered: September 2007
|
Member |
|
|
Hi, Im having performance issues with an Oracle Text query that makes multiple CONTAINS filters. Can you help me tuning it, because Im a begginer in this type of things and I don't know how to do it.
The query is:
SELECT /*+ FIRST_ROWS(50) */
(score (1) + score (2) + score (3)
) AS RANK, ID, TO_CHAR (dateinsert, 'dd/mm/yyyy')
FROM NOTICIAS
WHERE ( contains (resumen, v_palabra, 1) > 0
OR contains (insert, v_palabra, 2) > 0
OR contains (tema, v_palabra, 3) > 0
)
AND ouid = v_ouid
ORDER BY dateinsert DESC;
Someone told me I should'nt have so many "contains" in the query, is that right?.
Thanks in advance.
|
|
|