Page 1 of 1
Alias in index expression
Posted: Mon Sep 11, 2006 1:25 pm
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
Re: Alias in index expression
Posted: Mon Sep 11, 2006 3:35 pm
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.
Posted: Mon Sep 11, 2006 4:47 pm
by Maurizio
I use
index on field->beleg tag k_beleg
so I not declare the FIELD
Maurizio
Posted: Mon Sep 11, 2006 5:28 pm
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