Received: by 10.68.238.65 with SMTP id vi1mr13111135pbc.7.1340629648008;
        Mon, 25 Jun 2012 06:07:28 -0700 (PDT)
Path: l9ni18249pbj.0!nntp.google.com!news2.google.com!volia.net!news2.volia.net!feed-A.news.volia.net!news.musoftware.de!wum.musoftware.de!weretis.net!feeder4.news.weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail
From: Mladen Gogala <gogala.mla...@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: In Oracle, can one calculate statistics on non indexed  columns
Date: Mon, 25 Jun 2012 13:07:27 +0000 (UTC)
Organization: solani.org
Lines: 23
Message-ID: <pan.2012.06.25.13.07.27@gmail.com>
References: <f70d8c2d-9428-41fa-bf56-bf767ba7570c@googlegroups.com>
	<a576406f-1433-47f6-b505-e899bc7806af@googlegroups.com>
Mime-Version: 1.0
X-Trace: solani.org 1340629647 9766 eJwNwoERwEAEBMCWhHNPOSL0X8Jndt34sA/ohO8vjANLW9GMBJw2p7S26/NMLtHDlyIaKL0C6BBX (25 Jun 2012 13:07:27 GMT)
X-Complaints-To: abuse@news.solani.org
NNTP-Posting-Date: Mon, 25 Jun 2012 13:07:27 +0000 (UTC)
User-Agent: Pan/0.135 (Tomorrow I'll Wake Up and Scald Myself with Tea; GIT
	30dc37b master)
X-User-ID: eJwNx8EBADEEBMCWwlq0I47+S8jNbwgX7zCnG5dr0etH22D1eeViqJAMKZyc23MV/09VKokHFI4QjQ==
Cancel-Lock: sha1:h0xi3AhVoLC3H/8BaxvpeWPt9K0=
X-NNTP-Posting-Host: eJwFwQERACAIA8BKAjIwjsdc/wj+Z8AwtZHYqVSfZrt2Qc/gjaXjzlo3sir4YqzGhwZecT4J9RET
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

On Mon, 25 Jun 2012 04:03:20 -0700, zigzagdna wrote:


> Oracle text indexes are different than normalOracle indexes. One does
> not really use LIKE instead  uses contains.Also syntax for setting text
> indexes is different from normal index.
> 
> Micsrosoft sql server also has text indexes. But string statistics is
> for normal indexs, as for as I know.

You can also use open source text indexing software like Lucene or 
Sphinx, which have a myriad of options, work with any ODBC compliant 
database and are, generally speaking, much more advanced than the 
database specific text indexing software.
Sub-string analysis looks like a brain-dead feature which would slow down 
statistics gathering, without a real reason, because neither B*Tree 
indexes nor has indexes can be used for resolution of LIKE '%COND%' 
condition.



-- 
http://mgogala.byethost5.com