index "standard and text"

Hello!

Index can be defined as “standard and text” value. The documentation says that:

"This should be used for special cases only."

However it is not described what it is “special cases”.

When should I use this index “standard and text” to increase efficient search?

Thanks in advance!

best regards,
Dariusz Baumann

Adding any sort of index will add overhead : it takes more storage and inserting/updating will take longer. The more indices you have the more this overhead will be. Prehaps the phrase “special cases” is a little misleading. Use indices really where you want them and need them and don’t use indices for nodes you never query againest.


Stuart Fyffe-Collins
Software AG (UK) Ltd.