Databases Reference
In-Depth Information
We will now add an index on the title. However, we want to restrict the length of
this index to reduce the space used by the on-disk index structure. The
Create
an
index
on
1
columns
option is appropriate. So, we click on
Go
. In the next screen, we
specify the index details as shown here:
We fill in the following information in the options of this panel:
•
Index
name
: A name we invent, that describes the purpose of this index
•
Index
type
: We can choose
INDEX
•
Column
: We select the column that is used as the index, which is
title
•
Size
: We enter
30
instead of 100 (the complete length of the column) to save
space in the table's physical portion that holds index data
After saving this panel, we can confirm from the following screenshot that the index
is created and does not cover the entire length of the
title
column:
Search WWH ::
Custom Search