3
<title>analyze - TOra</title>
4
<meta http-equiv="Content-Type" content="text/html">
5
<meta name="description" content="TOra">
6
<meta name="generator" content="makeinfo 4.8">
7
<link title="Top" rel="start" href="index.html#Top">
8
<link rel="up" href="tools.html#tools" title="tools">
9
<link rel="prev" href="script.html#script" title="script">
10
<link rel="next" href="alert.html#alert" title="alert">
11
<link href="http://www.gnu.org/software/texinfo/" rel="generator-home" title="Texinfo Homepage">
13
This manual is for TOra, version 1.3.22.-->
14
<meta http-equiv="Content-Style-Type" content="text/css">
15
<style type="text/css"><!--
16
pre.display { font-family:inherit }
17
pre.format { font-family:inherit }
18
pre.smalldisplay { font-family:inherit; font-size:smaller }
19
pre.smallformat { font-family:inherit; font-size:smaller }
20
pre.smallexample { font-size:smaller }
21
pre.smalllisp { font-size:smaller }
22
span.sc { font-variant:small-caps }
23
span.roman { font-family:serif; font-weight:normal; }
24
span.sansserif { font-family:sans-serif; font-weight:normal; }
30
<a name="analyze"></a>
31
Next: <a rel="next" accesskey="n" href="alert.html#alert">alert</a>,
32
Previous: <a rel="previous" accesskey="p" href="script.html#script">script</a>,
33
Up: <a rel="up" accesskey="u" href="tools.html#tools">tools</a>
37
<h3 class="section">4.12 Statistics manager</h3>
39
<p><a name="index-Statistics-manager-28"></a>
40
This tool is usefull for collecting statistics and analyze tables in parallel. You can also use it to browse collected statistics.
42
<div class="block-image"><img src="images/analyze.png" alt="images/analyze.png"></div>
44
<p>You control the interface through the controls in the toolbar. The rest of the interface simply displays currently available tables in the current schema. When collecting statistics only the selected items in the tablelist are analyzed.
47
<dt>`<samp><span class="samp">Refresh</span></samp>'<dd>Refresh the table list from the database.
48
`<samp><span class="samp">Refresh</span></samp>'
50
<br><dt>`<samp><span class="samp">Schema</span></samp>'<dd>The next control is which schema to investigate tables for.
51
`<samp><span class="samp">Schema</span></samp>'
53
<br><dt>`<samp><span class="samp">Operation</span></samp>'<dd>What operation to perform. Select one of <strong>compute statistics</strong>, <strong>estimate statistics</strong>, <strong>delete statistics</strong> and <strong>validate references</strong>.
54
`<samp><span class="samp">Operation</span></samp>'
56
<br><dt>`<samp><span class="samp">Target</span></samp>'<dd>Depending on the <strong>operation</strong> you can sometimes select what kind of statistic to collect. Choose between <strong>all</strong>, <strong>table</strong>, <strong>indexed columns</strong> and <strong>local indexes</strong>.
57
`<samp><span class="samp">Target</span></samp>'
59
<br><dt>`<samp><span class="samp">Sample</span></samp>'<dd>If the <strong>operation</strong> is <strong>estimate statistics</strong> you can choose how large sample should be used to estimate the statistic information in percent of total amount of data.
60
`<samp><span class="samp">Sample</span></samp>'
62
<br><dt>`<samp><span class="samp">Parallel</span></samp>'<dd>Indicate the number of separate connections to open to the database and run collecting statistics concurrently when collecting.
63
`<samp><span class="samp">Parallel</span></samp>'
65
<br><dt>`<samp><span class="samp">Start analyzing</span></samp>'<dd>Press this button to perform the indicated operation on the tables selected in the list below the toolbar.
66
`<samp><span class="samp">Start analyzing</span></samp>'
68
<br><dt>`<samp><span class="samp">Stop</span></samp>'<dd>Stop current run. Before the stop button you can also see information about the currently running statistics gathering run if any is running.
69
`<samp><span class="samp">Stop</span></samp>'
added
removed
doc/help/tora/analyze.html
