Re: Query Optimization
Hi Rick,
thanks for your effort. I have solved the problem: I set a full text index on the column 'msg' and then changed the query part to:
"SELECT * FROM logs WHERE MATCH (msg) against ('*abrupt*' IN BOOLEAN MODE)".
The query is extremely fast.
Cheers, Nils
Subject
Views
Written By
Posted
4127
June 22, 2009 03:46AM
2282
June 23, 2009 09:12AM
Re: Query Optimization
2215
June 24, 2009 06:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.