Home » Server Options » Text & interMedia » Will "Contain clause" degrade the performance? (Oracle 10g, Windows 2000)
Will "Contain clause" degrade the performance? [message #475510] Wed, 15 September 2010 06:38 Go to next message
Messages: 67
Registered: April 2010

We have introduced context index and used Contain clause. Can I have some information on demerits or drawbacks of this approach.
Actally my concern is - Will "Contain clause" degrade the performance? if so, what are those points?

Re: Will "Contain clause" degrade the performance? [message #475567 is a reply to message #475510] Wed, 15 September 2010 14:20 Go to previous message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
The purpose of the context index and contains clause is to provide more options for searching text and to improve speed. However, if you have a small number of short rows, then you may be better off just using LIKE or INSTR. It would help if you would provide more details like your table structure, sample data, estimated amount of real data, sample searches, and expected results. If you are experiencing slowness there are various things that can be done to improve performance in certain situations.

Previous Topic: ORA-29900: operator binding does not exist
Next Topic: Search for Boolean Operator
Goto Forum:

Current Time: Fri Aug 19 01:07:38 CDT 2022