How to resolve a full table scan with “like” operator in where condition using Oracle ConText index:
Hi friends,
The article explains how to tune a full table scan while using like operator in where clause using Oracle ConText (interMEDIA) , CTXSYS schema install, and uninstall on Oracle 8i, Oracle 9i, Oracle 10g.
Oracle Text can perform linguistic analysis on documents as well as search text using various search patterns like keyword searching, Boolean searching, matching pattern searching, HTML, and XML searching. It supports CHAR, VARCHAR, VARCHAR2, LONG, LONG RAW, BLOB, CLOB, BFILE, Date, number datatype columns.
Please read and download the article of CTXSYS called “how to tune full table scan while using like operator” from the following link.
http://www.dbametrix.com/oracle-dba-tips.html
All the best,
Thanks and regards,
Leena Upadhyay.
When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.
This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.