<!-- $Header: /cvsroot/pgsql/doc/src/sgml/indices.sgml,v 1.17 2001/05/17 21:50:16 petere Exp $ -->

<!-- $Header: /cvsroot/pgsql/doc/src/sgml/indices.sgml,v 1.18 2001/05/22 16:00:00 petere Exp $ -->

<chapter id="indexes">

<title id="indexes-title">Indices</title>

<title id="indexes-title">Indexes</title>

<indexterm zone="indexes">

<primary>indexes</primary>

<!--

$Header: /cvsroot/pgsql/doc/src/sgml/sql.sgml,v 1.20 2001/03/24 23:03:26 petere Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/sql.sgml,v 1.21 2001/05/22 16:00:00 petere Exp $

-->

<chapter id="sql">

<title>Create Index</title>

<para>

Indices are used to speed up access to a relation. If a relation <classname>R</classname>

Indexes are used to speed up access to a relation. If a relation <classname>R</classname>

has an index on attribute <classname>A</classname> then we can

retrieve all tuples <replaceable>t</replaceable>

having