1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
|
<html>
<head>
<title>Table indices</title>
</head>
<body>
{%header:Indices%}
<br><br>
<font size=+2>Indices for table {%object_name%}</font><br>
<br><br>
<table cellspacing=1 cellpadding=2 border=0 bgcolor=0>
<tbody>
<tr bgcolor="navy">
{%NotSystem:
<td></td>
%}
<td valign="top"><b><font color=white>Index name</font></b></td>
<td valign="top"><b><font color=white>Type</font></b></td>
<td valign="top"><b><font color=white>Active</font></b></td>
<td valign="top"><b><font color=white>Unique</font></b></td>
<td valign="top"><b><font color=white>Fields</font></b></td>
<td valign="top"><b><font color=white>Statistics</font></b></td>
<td valign="top"><b><font color=white>Description</font></b></td>
</tr>
{%indices:
<tr bgcolor="{%varcolor:#DDDDFF/#CCCCFF%}">
{%ParentNotSystem:
<td valign="top" nowrap>
<a href="fr://index_action?type=DROP&parent_window={%parent_window%}&object_address={%object_address%}"><img src="{%fr_home%}/html-templates/drop.png"></a>
<a href="fr://index_action?type=RECOMPUTE&parent_window={%parent_window%}&object_address={%object_address%}"><img src="{%fr_home%}/html-templates/compute.png"></a>
</td>
%}
<td nowrap valign="top">{%object_name%}</td>
<td nowrap valign="top" align="center">{%index_type%}</td>
<td nowrap valign="top" align="center">{%ParentNotSystem:<a
href="fr://index_action?type=TOGGLE_ACTIVE&parent_window={%parent_window%}&object_address={%object_address%}">%}{%index_active%}{%ParentNotSystem:</a>%}</td>
<td nowrap valign="top" align="center">{%index_unique%}</td>
<td nowrap valign="top">{%index_fields%}</td>
<td nowrap valign="top" align="right">{%index_stats%}</td>
<td nowrap valign="top"><font size=-1>{%object_description%} {%ParentNotSystem:[<a
href="fr://edit_description?parent_window={%parent_window%}&object_address={%object_address%}&object_type=INDEX&object_name={%object_name%}">edit</a>]%}</font></td>
</tr>%}
</tbody>
</table>
<br><br>
{%NotSystem:
<a
href="fr://add_index?parent_window={%parent_window%}&object_address={%object_address%}">Create new index</a> | <a
href="fr://recompute_all?parent_window={%parent_window%}&object_address={%object_address%}">Recompute
statistics for all indices</a>
<br><br>
<table border=0 bgcolor="white" cellspacing=1 cellpadding=2>
<tr bgcolor="#CCCCFF">
<td><B>Icon</B></td>
<td nowrap><B>Click to...</B></td>
</tr>
<tr><td><img src="{%fr_home%}/html-templates/drop.png"></td><td>Drop index</td></tr>
<tr><td><img src="{%fr_home%}/html-templates/compute.png"></td><td>Recompute statistics for index</td></tr>
<tr><td><img src="{%fr_home%}/html-templates/ok.png"></td><td>Make index inactive</td></tr>
<tr><td><img src="{%fr_home%}/html-templates/redx.png"></td><td>Make index active</td></tr>
</table>
%}
</body>
</html>
|
