--- /dev/null
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD html 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+<head>
+<title>Appendix A. Hints list</title>
+<!-- Uncoment after the tool has been hosted somewhere.
+<link rel="home" title="pg_hint_plan" href="index.html">
+-->
+<link rel="stylesheet" type="text/css" href="style.css">
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
+</head>
+
+<body>
+<h1 id="pg_hint_plan">pg_hint_plan 1.0.0</h1>
+<div class="navigation">
+ <a href="pg_hint_plan-ja.html">pg_hint_plan</a> >
+ <a href="hint_list-ja.html">Appendix A. Hints list</a>
+</div>
+<hr>
+
+<h2 id="hint-list">Appendix A. Hints list</h2>
+<p>You can specify the hints with pg_hint_plan below </p>
+<table>
+<thead>
+<tr>
+<tr><th>Group</th><th>Format</th><th>Description</th></tr>
+</tr>
+</thead>
+<tbody>
+<tr><td rowspan="10" nowrap>Scan method</td>
+ <td nowrap>SeqScan(table)</td>
+ <td>Force an Seq Scan on table</td></tr>
+<tr><td>TidScan(table)</td>
+ <td>Force a Tid Scan on table. Only in searching with ctid</td></tr>
+<tr><td nowrap>IndexScan(table[ index...])</td>
+ <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>
+<tr><td nowrap>IndexOnlyScan(table[ index...])</td>
+ <td>Force an Index Only Scan or Index Scan on table. Yous can specify indexes like IndexScan() above</td></tr>
+<tr><td nowrap>BitmapScan(table[ index...])</td>
+ <td>Force a Bitmap Scan on table. Yous can specify indexes like IndexScan() above</td></tr>
+<tr><td nowrap>NoSeqScan(table)</td>
+ <td>Restraint a Seq Scan on table.</td></tr>
+<tr><td nowrap>NoTidScan(table)</td>
+ <td>Restraint a Tid Scan on table. </td></tr>
+<tr><td nowrap>NoIndexScan(table)</td>
+ <td>Restraint Index Scan or Index Only Scan on table. </td></tr>
+<tr><td nowrap>NoIndexOnlyScan(table)</td>
+ <td>Restraint an Index Only Scan on table. PostgreSQL 9.2 or after.</td></tr>
+<tr><td nowrap>NoBitmapScan(table)</td>
+ <td>Restraint a Bitmap Scan on table. </td></tr>
+
+<tr><td rowspan="6" nowrap>Join method</td>
+ <td nowrap>NestLoop(table table[ table...])</td>
+ <td>Force a Nested Loop as a Join method among specifiled tables.</td></tr>
+<tr><td nowrap>HashJoin(table table[ table...])</td>
+ <td>Force a Hash Join as a Join method among specifiled tables.</td></tr>
+<tr><td nowrap>MergeJoin(table table[ table...])</td>
+ <td>Force a Merge Join as a Join method among specifiled tables.</td></tr>
+<tr><td nowrap>NoNestLoop(table table[ table...])</td>
+ <td>Restraint a Nested Loop as a Join method among specifiled tables.</td></tr>
+<tr><td nowrap>NoHashJoin(table table[ table...])</td>
+ <td>Restraint Hash Join as a Join method among specifiled tables.</td></tr>
+<tr><td nowrap>NoMergeJoin(table table[ table...])</td>
+ <td>Restraint a Merge Join as a Join method among specifiled tables.</td></tr>
+
+<tr><td>Join order</td>
+ <td nowrap>Leading(table table[ table...])</td>
+ <td>Force join order in which table is specified. </td></tr>
+
+<tr><td>GUC</td>
+ <td nowrap>Set(GUC value)</td>
+ <td>While creating execution plan for this query , GUC is changed to specified value.</td></tr>
+</tbody>
+</table></p>
+
+
+<hr>
+<div class="navigation">
+ <a href="pg_hint_plan-ja.html">pg_hint_plan</a> >
+ <a href="hint_list-ja.html">Appendix A. hints list</a>
+</div>
+
+<p class="footer">Copyright (c) 2012, NIPPON TELEGRAPH AND TELEPHONE CORPORATION</p>
+
+<!--
+<script type="text/javascript">
+var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
+document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
+</script><script src="pg_statsinfo-ja_files/ga.js" type="text/javascript"></script>
+<script type="text/javascript">
+try{
+var pageTracker = _gat._getTracker("UA-10244036-6");
+pageTracker._trackPageview();
+} catch(err) {}
+</script>
+-->
+</body>
+</html>
OSDN Git Service
