Databases Reference
In-Depth Information
Here is how to fill in this panel:
•
•
•
•
Index name: A name we invent
Index type: We can choose
INDEX
or
UNIQUE
Field: We select the field that is used as the index, which is the
title
ield
Size: We enter
30
instead of
100
(the complete length of the field) to
save space
After saving this panel, we can confirm from the following screenshot that the index
is created and does not cover the whole length of the title field:
Multi-Field Indexes and Index Editing
In the next example, we assume that in a future application we will need to find the
topics written by a speciic author in a speciic language. It makes sense to expand
our
author_id
index, adding the
language
field to it.
We click the
Edit
link (small pencil) on the line containing the
author_id
index; this
brings us to the following panel, which shows the current state of this index:
Search WWH ::
Custom Search