As we have mentioned before the purpose behind indexing is to improve search performance. Since the indices must be kept up to date, and the appropriate index determined it is not an advantage to create every possible index due to the penalties when updating the data.

• 5.1 Regular Index
• 5.2 Metamorph Index