Re: In Oracle, can one calculate statistics on non indexed columns

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 25 Jun 2012 13:07:27 +0000 (UTC)
Message-ID: <pan.2012.06.25.13.07.27_at_gmail.com>



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
Received on Mon Jun 25 2012 - 08:07:27 CDT

Original text of this message