• R/O
  • HTTP
  • SSH
  • HTTPS

pg_hint_plan: Commit

firtst release


Commit MetaInfo

Revision48b34463dd3c571332aeae7aebc82b8dd61dc91e (tree)
Time2013-02-14 15:26:52
Authornaoki_kishi_b1 <kishi_naoki_b1@lab....>
Commiternaoki_kishi_b1

Log Message

Create an eng doc for hints list.

Signed-off-by: naoki_kishi_b1 <kishi_naoki_b1@lab.ntt.co.jp>

Change Summary

Incremental Difference

--- /dev/null
+++ b/doc/hint_list.html
@@ -0,0 +1,97 @@
1+<!DOCTYPE HTML PUBLIC "-//W3C//DTD html 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
2+<html>
3+<head>
4+<title>Appendix A. Hints list</title>
5+<!-- Uncoment after the tool has been hosted somewhere.
6+<link rel="home" title="pg_hint_plan" href="index.html">
7+-->
8+<link rel="stylesheet" type="text/css" href="style.css">
9+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
10+</head>
11+
12+<body>
13+<h1 id="pg_hint_plan">pg_hint_plan 1.0.0</h1>
14+<div class="navigation">
15+ <a href="pg_hint_plan-ja.html">pg_hint_plan</a> &gt;
16+ <a href="hint_list-ja.html">Appendix A. Hints list</a>
17+</div>
18+<hr>
19+
20+<h2 id="hint-list">Appendix A. Hints list</h2>
21+<p>You can specify the hints with pg_hint_plan below </p>
22+<table>
23+<thead>
24+<tr>
25+<tr><th>Group</th><th>Format</th><th>Description</th></tr>
26+</tr>
27+</thead>
28+<tbody>
29+<tr><td rowspan="10" nowrap>Scan method</td>
30+ <td nowrap>SeqScan(table)</td>
31+ <td>Force an Seq Scan on table</td></tr>
32+<tr><td>TidScan(table)</td>
33+ <td>Force a Tid Scan on table. Only in searching with ctid</td></tr>
34+<tr><td nowrap>IndexScan(table[ index...])</td>
35+ <td>Force an Index Scan on table. Yous can specify indexes and force to use the lower-cost index(es) among thr specified indexes. </td></tr>
36+<tr><td nowrap>IndexOnlyScan(table[ index...])</td>
37+ <td>Force an Index Only Scan or Index Scan on table. Yous can specify indexes like IndexScan() above</td></tr>
38+<tr><td nowrap>BitmapScan(table[ index...])</td>
39+ <td>Force a Bitmap Scan on table. Yous can specify indexes like IndexScan() above</td></tr>
40+<tr><td nowrap>NoSeqScan(table)</td>
41+ <td>Restraint a Seq Scan on table.</td></tr>
42+<tr><td nowrap>NoTidScan(table)</td>
43+ <td>Restraint a Tid Scan on table. </td></tr>
44+<tr><td nowrap>NoIndexScan(table)</td>
45+ <td>Restraint Index Scan or Index Only Scan on table. </td></tr>
46+<tr><td nowrap>NoIndexOnlyScan(table)</td>
47+ <td>Restraint an Index Only Scan on table. PostgreSQL 9.2 or after.</td></tr>
48+<tr><td nowrap>NoBitmapScan(table)</td>
49+ <td>Restraint a Bitmap Scan on table. </td></tr>
50+
51+<tr><td rowspan="6" nowrap>Join method</td>
52+ <td nowrap>NestLoop(table table[ table...])</td>
53+ <td>Force a Nested Loop as a Join method among specifiled tables.</td></tr>
54+<tr><td nowrap>HashJoin(table table[ table...])</td>
55+ <td>Force a Hash Join as a Join method among specifiled tables.</td></tr>
56+<tr><td nowrap>MergeJoin(table table[ table...])</td>
57+ <td>Force a Merge Join as a Join method among specifiled tables.</td></tr>
58+<tr><td nowrap>NoNestLoop(table table[ table...])</td>
59+ <td>Restraint a Nested Loop as a Join method among specifiled tables.</td></tr>
60+<tr><td nowrap>NoHashJoin(table table[ table...])</td>
61+ <td>Restraint Hash Join as a Join method among specifiled tables.</td></tr>
62+<tr><td nowrap>NoMergeJoin(table table[ table...])</td>
63+ <td>Restraint a Merge Join as a Join method among specifiled tables.</td></tr>
64+
65+<tr><td>Join order</td>
66+ <td nowrap>Leading(table table[ table...])</td>
67+ <td>Force join order in which table is specified. </td></tr>
68+
69+<tr><td>GUC</td>
70+ <td nowrap>Set(GUC value)</td>
71+ <td>While creating execution plan for this query , GUC is changed to specified value.</td></tr>
72+</tbody>
73+</table></p>
74+
75+
76+<hr>
77+<div class="navigation">
78+ <a href="pg_hint_plan-ja.html">pg_hint_plan</a> &gt;
79+ <a href="hint_list-ja.html">Appendix A. hints list</a>
80+</div>
81+
82+<p class="footer">Copyright (c) 2012, NIPPON TELEGRAPH AND TELEPHONE CORPORATION</p>
83+
84+<!--
85+<script type="text/javascript">
86+var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
87+document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
88+</script><script src="pg_statsinfo-ja_files/ga.js" type="text/javascript"></script>
89+<script type="text/javascript">
90+try{
91+var pageTracker = _gat._getTracker("UA-10244036-6");
92+pageTracker._trackPageview();
93+} catch(err) {}
94+</script>
95+-->
96+</body>
97+</html>
Show on old repository browser