In Oracle, can one calculate statistics on non indexed columns
From: <zigzagdna_at_yahoo.com>
Date: Sun, 24 Jun 2012 19:37:57 -0700 (PDT)
Message-ID: <f70d8c2d-9428-41fa-bf56-bf767ba7570c_at_googlegroups.com>
Date: Sun, 24 Jun 2012 19:37:57 -0700 (PDT)
Message-ID: <f70d8c2d-9428-41fa-bf56-bf767ba7570c_at_googlegroups.com>
- 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?
- 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?