Will "Contain clause" degrade the performance? [message #475510] |
Wed, 15 September 2010 06:38 |
oraranjangmailcom
Messages: 67 Registered: April 2010
|
Member |
|
|
Hi,
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?
Thanks,
Ranjan
|
|
|
Re: Will "Contain clause" degrade the performance? [message #475567 is a reply to message #475510] |
Wed, 15 September 2010 14:20 |
|
Barbara Boehmer
Messages: 9102 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.
|
|
|