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

From: <>
Date: Sun, 24 Jun 2012 19:54:09 -0700 (PDT)
Message-ID: <>

On Sunday, June 24, 2012 10:37:57 PM UTC-4, (unknown) wrote:
> 1. I am learning SQL Server 2008. I see that sql server calculates statistics on non indexed columns as well and makes use of such statistics in determining best query plan. I also see something like this in Teradata. Does Oracle do anything like that, if not why not?
> 2. Another thing I noticed that SQL Server calculates string statistics, i.e., for a varcahr column statistics on all substrings in that column. This statistics is useful when where clause uses LIKE:
> name like %Christ%. Is there anything like in Oracle?

Oh well, I found something on googel about my fisrt question but not second. Received on Sun Jun 24 2012 - 21:54:09 CDT

Original text of this message