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>


  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?
Received on Sun Jun 24 2012 - 21:37:57 CDT

Original text of this message