Alias in index expression

Post Reply
User avatar
Otto
Posts: 4470
Joined: Fri Oct 07, 2005 7:07 pm
Contact:

Alias in index expression

Post by Otto »

Is there an advantage of using an ALIAS in the index-expression:
index on kasse->beleg tag k_beleg
or
index on beleg tag k_beleg

Thanks in advance
Otto
R.F.
Posts: 840
Joined: Thu Oct 13, 2005 7:05 pm

Re: Alias in index expression

Post by R.F. »

Otto wrote:Is there an advantage of using an ALIAS in the index-expression:
index on kasse->beleg tag k_beleg
or
index on beleg tag k_beleg

Thanks in advance
Otto
None at all, in fact, you should avoid the use of use of alias in index expressions, specially if you are using Advantage Database Server, or if you are working with dynamic aliases.
Saludos
R.F.
User avatar
Maurizio
Posts: 705
Joined: Mon Oct 10, 2005 1:29 pm
Contact:

Post by Maurizio »

I use

index on field->beleg tag k_beleg

so I not declare the FIELD

Maurizio
User avatar
Otto
Posts: 4470
Joined: Fri Oct 07, 2005 7:07 pm
Contact:

Post by Otto »

Rene, thank you for your answer. Advantage is my problem therefore I have to change. I couldn't remember why I used the Alias.

Hello Maurizio,
I was very happy to see you and your family here in Sillian.
The evening was too short.
Greetings from all of us
Otto
Post Reply