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>
Date: Mon, 25 Jun 2012 01:22:30 -0700 (PDT)
Message-ID: <dd09e12e-6e2a-4b53-abd0-9a86f3a271ed_at_googlegroups.com>
- 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.
- 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