@@ -41,7 +41,7 @@ CREATE [ UNIQUE ] INDEX <replaceable class="parameter">index_name</replaceable>
41
41
<LISTITEM>
42
42
<PARA>
43
43
Causes the system to check for
44
- duplicate values when the index is created (if data
44
+ duplicate values in the table when the index is created (if data
45
45
already exist) and each time data is added. Attempts to
46
46
insert or update non-duplicate data will generate an
47
47
error.
@@ -76,7 +76,7 @@ CREATE [ UNIQUE ] INDEX <replaceable class="parameter">index_name</replaceable>
76
76
<PARA>
77
77
the name of the access method which is to be used for
78
78
the index. The default access method is BTREE.
79
- Postgres provides three access methods for secondary indices :
79
+ Postgres provides three access methods for secondary indexes :
80
80
<variablelist>
81
81
<varlistentry>
82
82
<term>BTREE</term>
@@ -208,14 +208,14 @@ SELECT am.amname AS acc_name,
208
208
Description
209
209
</TITLE>
210
210
<PARA>
211
- This command constructs an index
211
+ <command>CREATE INDEX</ command> constructs an index
212
212
<replaceable class="parameter">index_name</replaceable>.
213
213
on the specified
214
214
<replaceable class="parameter">table</replaceable>.
215
215
216
216
<tip>
217
217
<para>
218
- Indices are primarily used to enhance database performance.
218
+ Indexes are primarily used to enhance database performance.
219
219
But inappropriate use will result in slower performance.
220
220
</tip>
221
221
@@ -236,7 +236,7 @@ But inappropriate use will result in slower performance.
236
236
on the result of a user-defined function
237
237
<replaceable class="parameter">func_name</replaceable> applied
238
238
to one or more attributes of a single class. These functional
239
- indices can be used to obtain fast access to data
239
+ indexes can be used to obtain fast access to data
240
240
based on operators that would normally require some
241
241
transformation to apply them to the base data.
242
242
</para>
@@ -250,7 +250,7 @@ But inappropriate use will result in slower performance.
250
250
</TITLE>
251
251
<PARA>
252
252
Currently, only the BTREE access method supports multi-column
253
- indices . Up to 7 keys may be specified.
253
+ indexes . Up to 7 keys may be specified.
254
254
</PARA>
255
255
<para>
256
256
Use <command>DROP INDEX</command>
0 commit comments