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

From: dombrooks <dombrooks_at_hotmail.com>
Date: Mon, 25 Jun 2012 01:22:30 -0700 (PDT)
Message-ID: <dd09e12e-6e2a-4b53-abd0-9a86f3a271ed_at_googlegroups.com>


  1. Yes - see user_tab_col_statistics and if using histograms then user_histograms. To what extent histograms are calculated will depend on how you gather statistics.
  2. The best performing solution for searching for substrings with both leading and trailing wildcards will usually be an Oracle Text index otherwise a search on something like %Christ% cannot efficiently use a index to identify such rows. See http://docs.oracle.com/cd/E11882_01/text.112/e24435/toc.htm
Received on Mon Jun 25 2012 - 03:22:30 CDT

Original text of this message