1
<HTML><HEAD><TITLE>Statistics manager</TITLE></HEAD><BODY>
2
<H1>Statistics manager</H1>
3
This tool is usefull for collecting statistics and analyze tables in parallel. You can also
4
use it to browse collected statistics.<P>
5
<IMG SRC=images/analyze.png><P>
6
You control the interface through the controls in the toolbar. The rest of the interface simply
7
displays currently available tables in the current schema. When collecting statistics only the
8
selected items in the tablelist are analyzed.<P>
10
<TR><TD VALIGN=top><B>
13
Refresh the table list from the database.
15
<TR><TD VALIGN=top><B>
18
The next control is which schema to investigate tables for.
20
<TR><TD VALIGN=top><B>
23
What operation to perform. Select one of <B>compute statistics</B>, <B>estimate statistics</B>, <B>delete statistics</B> and <B>validate references</B>.
25
<TR><TD VALIGN=top><B>
28
Depending on the <B>operation</B> you can sometimes select what kind of statistic to collect. Choose between <B>all</B>, <B>table</B>, <B>indexed columns</B> and <B>local indexes</B>.
30
<TR><TD VALIGN=top><B>
33
If the <B>operation</B> is <B>estimate statistics</B> you can choose how large sample should be used to estimate the statistic information in percent of
36
<TR><TD VALIGN=top><B>
39
Indicate the number of separate connections to open to the database and run collecting statistics concurrently when collecting.
41
<TR><TD VALIGN=top><B>
44
Press this button to perform the indicated operation on the tables selected in the list below the toolbar.
46
<TR><TD VALIGN=top><B>
49
Stop current run. Before the stop button you can also see information about the currently running statistics gathering run if any is running.