<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head profile="http://internetalchemy.org/2003/02/profile">
<link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" />
<link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" />
<meta name="dc.title" content="Function: sys_stat_analyze - Virtuoso Functions Guide" />
<meta name="dc.subject" content="Function: sys_stat_analyze - Virtuoso Functions Guide" />
<meta name="dc.creator" content="OpenLink Software Documentation Team ; " />
<meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" />
<link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" />
<link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" />
<link rel="parent" href="functions.html" title="Chapter Contents" />
<link rel="prev" href="appendixa.html" title="Appendix" />
<link rel="next" href="functions.html#.html" title="" />
<link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="doc.css" />
<link rel="stylesheet" type="text/css" href="/doc/translation.css" />
<title>Function: sys_stat_analyze - Virtuoso Functions Guide</title>
<meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
<meta name="author" content="OpenLink Software Documentation Team ; " />
<meta name="copyright" content="OpenLink Software, 1999 - 2009" />
<meta name="keywords" content="" />
<meta name="GENERATOR" content="OpenLink XSLT Team" />
</head>
<body>
<div id="header">
<a name="fn_sys_stat_analyze" />
<img src="../images/misc/logo.jpg" alt="" />
<h1>22. Virtuoso Functions Guide - sys_stat_analyze</h1>
</div>
<div id="navbartop">
<div>
<a class="link" href="functions.html">Chapter Contents</a> | <a class="link" href="fn_sinv_drop_inverse.html" title="sinv_drop_inverse">Prev</a> | <a class="link" href="fn_sys_stat_histogram.html" title="sys_stat_histogram">Next</a>
</div>
</div>
<div id="currenttoc">
<form method="post" action="/doc/adv_search.vspx">
<div class="search">Keyword Search: <br />
<input type="text" name="q" /> <input type="submit" name="go" value="Go" />
</div>
</form>
<div>
<a href="http://www.openlinksw.com/">www.openlinksw.com</a>
</div>
<div>
<a href="http://docs.openlinksw.com/">docs.openlinksw.com</a>
</div>
<br />
<div>
<a href="index.html">Book Home</a>
</div>
<br />
<div>
<a href="contents.html">Contents</a>
</div>
<div>
<a href="preface.html">Preface</a>
</div>
<br />
<div>
<a class="selected" href="functions.html">Virtuoso Functions Guide</a>
</div>
<br />
<div>
<a href="functions.html#admin">Administration</a>
</div>
<div>
<a href="functions.html#aggr">Aggregate Functions</a>
</div>
<div>
<a href="functions.html#array">Array Manipulation</a>
</div>
<div>
<a href="functions.html#bpel">BPEL APIs</a>
</div>
<div>
<a href="functions.html#backup">Backup</a>
</div>
<div>
<a href="functions.html#compression">Compression</a>
</div>
<div>
<a href="functions.html#cursors">Cursor</a>
</div>
<div>
<a href="functions.html#time">Date & Time Manipulation</a>
</div>
<div>
<a href="functions.html#debug">Debug</a>
</div>
<div>
<a href="functions.html#dict">Dictionary Manipulation</a>
</div>
<div>
<a href="functions.html#encoding">Encoding & Decoding</a>
</div>
<div>
<a href="functions.html#file">File Manipulation</a>
</div>
<div>
<a href="functions.html#ft">Free Text</a>
</div>
<div>
<a href="functions.html#hash">Hashing / Cryptographic</a>
</div>
<div>
<a href="functions.html#ldap">LDAP</a>
</div>
<div>
<a href="functions.html#localization">Locale</a>
</div>
<div>
<a href="functions.html#mail">Mail</a>
</div>
<div>
<a href="functions.html#misc">Miscellaneous</a>
</div>
<div>
<a href="functions.html#number">Number</a>
</div>
<div>
<a href="functions.html#phrz">Phrases</a>
</div>
<div>
<a href="functions.html#rdf">RDF data</a>
</div>
<div>
<a href="functions.html#rmt">Remote SQL Data Source</a>
</div>
<div>
<a href="functions.html#repl">Replication</a>
</div>
<div>
<a href="functions.html#soap">SOAP</a>
</div>
<div>
<a class="selected" href="functions.html#sql">SQL</a>
</div>
<div class="selected">
<div>
<a href="fn___any_grants.html">__any_grants</a>
</div>
<div>
<a href="fn_exec_close.html">close</a>
</div>
<div>
<a href="fn_collation_define.html">collation_define</a>
</div>
<div>
<a href="fn_complete_table_name.html">complete_table_name</a>
</div>
<div>
<a href="fn_delay.html">delay</a>
</div>
<div>
<a href="fn_end_result.html">end_result</a>
</div>
<div>
<a href="fn_exec.html">exec</a>
</div>
<div>
<a href="fn_exec_metadata.html">exec_metadata</a>
</div>
<div>
<a href="fn_exec_next.html">exec_next</a>
</div>
<div>
<a href="fn_exec_result.html">exec_result</a>
</div>
<div>
<a href="fn_exec_result_names.html">exec_result_names</a>
</div>
<div>
<a href="fn_exec_score.html">exec_score</a>
</div>
<div>
<a href="fn_identity_value.html">identity_value</a>
</div>
<div>
<a href="fn_name_part.html">name_part</a>
</div>
<div>
<a href="fn_registry_get.html">registry_get</a>
</div>
<div>
<a href="fn_registry_get_all.html">registry_get_all</a>
</div>
<div>
<a href="fn_registry_name_is_protected.html">registry_name_is_pro...</a>
</div>
<div>
<a href="fn_registry_remove.html">registry_remove</a>
</div>
<div>
<a href="fn_registry_set.html">registry_set</a>
</div>
<div>
<a href="fn_result.html">result</a>
</div>
<div>
<a href="fn_result_names.html">result_names</a>
</div>
<div>
<a href="fn_row_count.html">row_count</a>
</div>
<div>
<a href="fn_sequence_get_all.html">sequence_get_all</a>
</div>
<div>
<a href="fn_sequence_next.html">sequence_next</a>
</div>
<div>
<a href="fn_sequence_remove.html">sequence_remove</a>
</div>
<div>
<a href="fn_sequence_set.html">sequence_set</a>
</div>
<div>
<a href="fn_set_identity_column.html">set_identity_column</a>
</div>
<div>
<a href="fn_set_row_count.html">set_row_count</a>
</div>
<div>
<a href="fn_set_user_id.html">set_user_id</a>
</div>
<div>
<a href="fn_signal.html">signal</a>
</div>
<div>
<a href="fn_sinv_create_inverse.html">sinv_create_inverse</a>
</div>
<div>
<a href="fn_sinv_create_key_mapping.html">sinv_create_key_mapp...</a>
</div>
<div>
<a href="fn_sinv_drop_inverse.html">sinv_drop_inverse</a>
</div>
<div>
<a class="selected" href="fn_sys_stat_analyze.html">sys_stat_analyze</a>
</div>
<div>
<a href="fn_sys_stat_histogram.html">sys_stat_histogram</a>
</div>
<div>
<a href="fn_table_drop_policy.html">table_drop_policy</a>
</div>
<div>
<a href="fn_table_set_policy.html">table_set_policy</a>
</div>
<div>
<a href="fn_username.html">username</a>
</div>
</div>
<div>
<a href="functions.html#string">String</a>
</div>
<div>
<a href="functions.html#txn">Transaction</a>
</div>
<div>
<a href="functions.html#type">Type Mapping</a>
</div>
<div>
<a href="functions.html#uddi">UDDI</a>
</div>
<div>
<a href="functions.html#udt">User Defined Types & The CLR</a>
</div>
<div>
<a href="functions.html#vad">VAD</a>
</div>
<div>
<a href="functions.html#jvmpl">Virtuoso Java PL API</a>
</div>
<div>
<a href="functions.html#bif">Virtuoso Server Extension Interface (VSEI)</a>
</div>
<div>
<a href="functions.html#ws">Web & Internet</a>
</div>
<div>
<a href="functions.html#xml">XML</a>
</div>
<div>
<a href="functions.html#XPATH">XPATH & XQUERY</a>
</div>
<br />
<div>
<a href="functionidx.html">Functions Index</a>
</div>
<br />
</div>
<div id="text">
<h2>sys_stat_analyze</h2>
<div class="refpurpose">Collects statistics on a table and its columns for use in SQL optimization</div>
<div class="funcsynopsis">
<span class="funcdef">
<span class="function">sys_stat_analyze</span>
</span>
(<span class="paramdef">in <span class="parameter">table_name</span> varchar</span>,
<span class="paramdefoptional">[in <span class="optional">pcnt</span> integer]</span>,
<span class="paramdefoptional">[in <span class="optional">ignore_vdb</span> integer]</span>);
</div>
<div class="refsect1">
<div class="refsect1title">Description</div>
<p>
Collects (or updates) column statistics for the table columns.
It collects minimum, maximum average and distinct values for a column and a
row count for the table and inserts the data into the DB.DBA.SYS_COL_STAT table.
It does not make histograms for the columns.</p>
<p>
The statistics are then used by the Optimized SQL compiler. All the cached compilations are
discarded, because some of them may compile differently in the light of the new data.
</p>
<p>This function will normally consider the entire database with the exception
of remote tables. Since you may be concerned about time or remote tables this
operation is configurable using the optional parameters,
<span class="computeroutput">pcnt</span> and <span class="computeroutput">ignore_vdb</span>.</p>
</div>
<div class="refsect1">
<div class="refsect1title">Parameters</div>
<div class="refsect2">
<span class="refsect2title">table_name – </span>
The full name of the table exactly as in the KEY_TABLE column of SYS_KEYS.</div>
<div class="refsect2">
<span class="refsect2title">pcnt – </span>
Determines the sample size for statistics gathering.
A value of 0 will read the whole table. The default is 5, for an approximately five percentsample of the table.
</div>
<div class="refsect2">
<span class="refsect2title">ignore_vdb – </span>
Determines whether remote tables are considered. By default
remote tables (ignore_vdb = 1) are ignored. Setting this value to 0
will cause this function to gather statistical information for remote
tables also. A percentage of 0 will read the remote table from beginning to end. A non-zero percentage will access the statistics tables of the remote DBMS if it is of a supported type, see the sys_stat_vdb_mappers table. </div>
</div>
<div class="refsect1">
<div class="refsect1title">See Also</div>
<p>
<a href="fn_sys_stat_histogram.html">sys_stat_histogram</a>
</p>
<p>
<a href="fn_SYS_DB_STAT.html">SYS_DB_STAT()</a>
</p>
</div>
</div>
<div id="footer">
<div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div>
<div id="validation">
<a href="http://validator.w3.org/check/referer">
<img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" />
</a>
<a href="http://jigsaw.w3.org/css-validator/">
<img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" />
</a>
</div>
</div>
</body>
</html>
distrib
>
Fedora
>
14
>
x86_64
>
media
>
updates
>
by-pkgid
>
71d40963b505df4524269198e237b3e3
>
files
>
614
