Re: In Oracle, can one calculate statistics on non indexed columns
From: <zigzagdna_at_yahoo.com>
Date: Sun, 24 Jun 2012 19:54:09 -0700 (PDT)
Message-ID: <439467b7-ac08-437a-a21f-123023446f4e_at_googlegroups.com>
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?
Date: Sun, 24 Jun 2012 19:54:09 -0700 (PDT)
Message-ID: <439467b7-ac08-437a-a21f-123023446f4e_at_googlegroups.com>
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.
https://forums.oracle.com/forums/thread.jspa?threadID=2268501 Received on Sun Jun 24 2012 - 21:54:09 CDT