llowing command can be used to create an index on the
   <TT
CLASS="STRUCTFIELD"
>id</TT
> column, as discussed:
</P><PRE
CLASS="PROGRAMLISTING"
>CREATE INDEX test1_id_index ON test1 (id);</PRE
><P>
   The name <TT
CLASS="STRUCTNAME"
>test1_id_index</TT
> can be chosen
   freely, but you should pick something that enables you to remember
   later what the index was for.
  </P
><P
>   To remove an index, use the <TT
CLASS="COMMAND"
>DROP INDEX</TT
> command.
   Indexes can be added to and removed from tables