it makes sense to use parts of keys provided are used those with the highest
level because significantly reduce the readings otherwise should build an
index for that purpose. greetings




-------Messaggio originale-------

Da: brucedickinson@... [firebird-support]
Data: 20/07/2015 14.20.37
A: firebird-support@yahoogroups.com
Oggetto: Re: Rif: [firebird-support] Re: Is it possible to use only "part"
of the index?


So, if I change the order of fields in the index I can speed things up.
Could someone explain me why it works like it works? What are the internals
behind this?



[Non-text portions of this message have been removed]