How to install-uninstall CTXSYS schema in Oracle 8i,Oracle 9i and Oracle 10g

April 27, 2010 | By

How to resolve full table scan with “like” operator in where condition using Oracle ConText index:

Hi friends,

Article explains how to tune 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 a various search patterns like keyword searching, Boolean searching, matching pattern searching,HTML and XML searching. It support CHAR, VARCHAR, VARCHAR2, LONG, LONG RAW, BLOB, CLOB, BFILE, Date, number datatype columns.

Please read and download article of CTXSYS called “how to tune full table scan while using like operator” from following link.
http://www.dbametrix.com/oracle-dba-tips.html

All the best,
Thanks and regards,
Leena Upadhyay.

Be Sociable, Share!

Tags: , , , , , , , , , , , , , ,

Category: blog, blogging, DBA, Uncategorized

Comments are closed.