Kbase 13021: How/Why to use the Abbreviate option when defining an index
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
How/Why to use the Abbreviate option when defining an index
The most important thing to understand is that marking an index
as abbreviated has absolutely no impact on the way the index is
stored. The only effect of making an index "abbreviated" is the
interpretation of USING by the compiler.
If an index is abbreviated, FIND X USING Y is interpreted as
FIND X WHERE Y BEGINS INPUT Y. If not abbreviated, it behaves
as if you said FIND X WHERE Y = INPUT Y. Therefore you should
never agonize over marking an index as abbreviated from a
performance standpoint. Your only concern should be the desired
default interpretation of USING. If you normally don't
use the USING syntax construct, you can ignore the abbreviated
index attribute altogether.
For additional information please refer to the following
documentation:
Language Tutorial, Chapter 5 page 35 and 36.
Progress Software Technical Support Note # 13021