← Back to branch summary

~ubuntu-branches/ubuntu/oneiric/postgresql-9.1/oneiric-security

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/indexes.html

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2011-05-11 10:41:53 UTC
  • Revision ID: james.westby@ubuntu.com-20110511104153-psbh2o58553fv1m0
Tags: upstream-9.1~beta1
Import upstream version 9.1~beta1

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/src/sgml/html/indexes.html
 
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
 
5
>Indexes</TITLE
 
6
><META
 
7
NAME="GENERATOR"
 
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
 
9
REV="MADE"
 
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
 
11
REL="HOME"
 
12
TITLE="PostgreSQL 9.1beta1 Documentation"
 
13
HREF="index.html"><LINK
 
14
REL="UP"
 
15
TITLE="The SQL Language"
 
16
HREF="sql.html"><LINK
 
17
REL="PREVIOUS"
 
18
TITLE="UNION, CASE, and Related Constructs"
 
19
HREF="typeconv-union-case.html"><LINK
 
20
REL="NEXT"
 
21
TITLE="Introduction"
 
22
HREF="indexes-intro.html"><LINK
 
23
REL="STYLESHEET"
 
24
TYPE="text/css"
 
25
HREF="stylesheet.css"><META
 
26
HTTP-EQUIV="Content-Type"
 
27
CONTENT="text/html; charset=ISO-8859-1"><META
 
28
NAME="creation"
 
29
CONTENT="2011-04-27T21:20:33"></HEAD
 
30
><BODY
 
31
CLASS="CHAPTER"
 
32
><DIV
 
33
CLASS="NAVHEADER"
 
34
><TABLE
 
35
SUMMARY="Header navigation table"
 
36
WIDTH="100%"
 
37
BORDER="0"
 
38
CELLPADDING="0"
 
39
CELLSPACING="0"
 
40
><TR
 
41
><TH
 
42
COLSPAN="5"
 
43
ALIGN="center"
 
44
VALIGN="bottom"
 
45
><A
 
46
HREF="index.html"
 
47
>PostgreSQL 9.1beta1 Documentation</A
 
48
></TH
 
49
></TR
 
50
><TR
 
51
><TD
 
52
WIDTH="10%"
 
53
ALIGN="left"
 
54
VALIGN="top"
 
55
><A
 
56
TITLE="UNION, CASE, and Related Constructs"
 
57
HREF="typeconv-union-case.html"
 
58
ACCESSKEY="P"
 
59
>Prev</A
 
60
></TD
 
61
><TD
 
62
WIDTH="10%"
 
63
ALIGN="left"
 
64
VALIGN="top"
 
65
><A
 
66
TITLE="Type Conversion"
 
67
HREF="typeconv.html"
 
68
>Fast Backward</A
 
69
></TD
 
70
><TD
 
71
WIDTH="60%"
 
72
ALIGN="center"
 
73
VALIGN="bottom"
 
74
></TD
 
75
><TD
 
76
WIDTH="10%"
 
77
ALIGN="right"
 
78
VALIGN="top"
 
79
><A
 
80
TITLE="Full Text Search"
 
81
HREF="textsearch.html"
 
82
>Fast Forward</A
 
83
></TD
 
84
><TD
 
85
WIDTH="10%"
 
86
ALIGN="right"
 
87
VALIGN="top"
 
88
><A
 
89
TITLE="Introduction"
 
90
HREF="indexes-intro.html"
 
91
ACCESSKEY="N"
 
92
>Next</A
 
93
></TD
 
94
></TR
 
95
></TABLE
 
96
><HR
 
97
ALIGN="LEFT"
 
98
WIDTH="100%"></DIV
 
99
><DIV
 
100
CLASS="CHAPTER"
 
101
><H1
 
102
><A
 
103
NAME="INDEXES"
 
104
></A
 
105
>Chapter 11. Indexes</H1
 
106
><DIV
 
107
CLASS="TOC"
 
108
><DL
 
109
><DT
 
110
><B
 
111
>Table of Contents</B
 
112
></DT
 
113
><DT
 
114
>11.1. <A
 
115
HREF="indexes-intro.html"
 
116
>Introduction</A
 
117
></DT
 
118
><DT
 
119
>11.2. <A
 
120
HREF="indexes-types.html"
 
121
>Index Types</A
 
122
></DT
 
123
><DT
 
124
>11.3. <A
 
125
HREF="indexes-multicolumn.html"
 
126
>Multicolumn Indexes</A
 
127
></DT
 
128
><DT
 
129
>11.4. <A
 
130
HREF="indexes-ordering.html"
 
131
>Indexes and <TT
 
132
CLASS="LITERAL"
 
133
>ORDER BY</TT
 
134
></A
 
135
></DT
 
136
><DT
 
137
>11.5. <A
 
138
HREF="indexes-bitmap-scans.html"
 
139
>Combining Multiple Indexes</A
 
140
></DT
 
141
><DT
 
142
>11.6. <A
 
143
HREF="indexes-unique.html"
 
144
>Unique Indexes</A
 
145
></DT
 
146
><DT
 
147
>11.7. <A
 
148
HREF="indexes-expressional.html"
 
149
>Indexes on Expressions</A
 
150
></DT
 
151
><DT
 
152
>11.8. <A
 
153
HREF="indexes-partial.html"
 
154
>Partial Indexes</A
 
155
></DT
 
156
><DT
 
157
>11.9. <A
 
158
HREF="indexes-opclass.html"
 
159
>Operator Classes and Operator Families</A
 
160
></DT
 
161
><DT
 
162
>11.10. <A
 
163
HREF="indexes-collations.html"
 
164
>Indexes and Collations</A
 
165
></DT
 
166
><DT
 
167
>11.11. <A
 
168
HREF="indexes-examine.html"
 
169
>Examining Index Usage</A
 
170
></DT
 
171
></DL
 
172
></DIV
 
173
><P
 
174
>  Indexes are a common way to enhance database performance.  An index
 
175
  allows the database server to find and retrieve specific rows much
 
176
  faster than it could do without an index.  But indexes also add
 
177
  overhead to the database system as a whole, so they should be used
 
178
  sensibly.
 
179
 </P
 
180
></DIV
 
181
><DIV
 
182
CLASS="NAVFOOTER"
 
183
><HR
 
184
ALIGN="LEFT"
 
185
WIDTH="100%"><TABLE
 
186
SUMMARY="Footer navigation table"
 
187
WIDTH="100%"
 
188
BORDER="0"
 
189
CELLPADDING="0"
 
190
CELLSPACING="0"
 
191
><TR
 
192
><TD
 
193
WIDTH="33%"
 
194
ALIGN="left"
 
195
VALIGN="top"
 
196
><A
 
197
HREF="typeconv-union-case.html"
 
198
ACCESSKEY="P"
 
199
>Prev</A
 
200
></TD
 
201
><TD
 
202
WIDTH="34%"
 
203
ALIGN="center"
 
204
VALIGN="top"
 
205
><A
 
206
HREF="index.html"
 
207
ACCESSKEY="H"
 
208
>Home</A
 
209
></TD
 
210
><TD
 
211
WIDTH="33%"
 
212
ALIGN="right"
 
213
VALIGN="top"
 
214
><A
 
215
HREF="indexes-intro.html"
 
216
ACCESSKEY="N"
 
217
>Next</A
 
218
></TD
 
219
></TR
 
220
><TR
 
221
><TD
 
222
WIDTH="33%"
 
223
ALIGN="left"
 
224
VALIGN="top"
 
225
><TT
 
226
CLASS="LITERAL"
 
227
>UNION</TT
 
228
>, <TT
 
229
CLASS="LITERAL"
 
230
>CASE</TT
 
231
>, and Related Constructs</TD
 
232
><TD
 
233
WIDTH="34%"
 
234
ALIGN="center"
 
235
VALIGN="top"
 
236
><A
 
237
HREF="sql.html"
 
238
ACCESSKEY="U"
 
239
>Up</A
 
240
></TD
 
241
><TD
 
242
WIDTH="33%"
 
243
ALIGN="right"
 
244
VALIGN="top"
 
245
>Introduction</TD
 
246
></TR
 
247
></TABLE
 
248
></DIV
 
249
></BODY
 
250
></HTML
 
251
>
 
 
b'\\ No newline at end of file'