>when i use a command to create an index:
>"index on xx+yy to ...." i have a time
>if i write:
>"index on xx+yy for aa#bb" my performance degrade
> until the 300%
>if i write the command in this way:
>"index on xx+yy for aa>0" my performance are better
>but degrade until th 100%
>
>thanks
Vincenzo,
If you are speaking about the time it takes to create the indexes, well that's an issue of optimization.
INDEX ON xx+yy FOR aa#bb ...
will run faster if an index exists already on aa
INDEX ON xx+yy FOR aa>0
again will run faster if an index exists on aa
INDEX ON xx+yy
will always be faster than other two, regardless of the resence or absense of indexes, because there is no filtering of records to be done during the indexing.
You may find that overall performance is beenfitted by keeping indexes on xx+yy, aa, and bb and then;
USE TableA TAG
SET FILTER TO aa#bb
