Hi to all

One question .. If I create two fields, first with not null and indexed
unique, second field not null. And create Primary Key with frist and
second field with this order. The second field are used for FK with
other tables. First field always get an unique numeric value from one
gen_id. All fields are integer.

When.. I search one record with there fields order. It's most slow ?
What is the correct order for maximize relations/transactions speed with
index ?
I think.. order of fields and order of primary key definition, is not a
problem...
I think.. the system (firebird) use apropiate index for any SQL
transaction.

And I see .. If change order of any index, to "desc", system (firebird)
create the same index table and index data, but neg first all bits. It's
true ? It is good ? If firebird use index with "stack pointers" (first
in first out) .. to create table index and for desc indexes use inverse
"stack pointers" (first in last out) It's not a two index orders ? I
think that. Firebird negate bit to bit, data pointer to search in desc
indexes ? It's for economize length of code ? Same functions for neg
stored data.. I don't know ..

Thanks to all
and Sorry for my English

--
-----------------------------
Aracil Informática
German Aracil Boned
Tel : 96 129 43 44
http://www.tecnoxarxa.com
http://www.notasenred.com
-----------------------------





--
-----------------------------
Aracil Informática

German Aracil Boned
E-mail: german@...
Tel : 96 129 43 44
http://www.tecnoxarxa.com
http://www.notasenred.com
-----------------------------
Este mensaje de correo electrónico y sus documentos adjuntos están dirigidos EXCLUSIVAMENTE a los destinatarios especificados. La información contenida puede ser CONFIDENCIAL y/o estar LEGALMENTE PROTEGIDA y no necesariamente refleja la opinión de Aracil Informática SL. Si usted recibe este mensaje por ERROR, por favor comuníqueselo inmediatamente al remitente y ELIMINELO ya que usted NO ESTA AUTORIZADO al uso, revelación, distribución, impresión o copia de toda o alguna parte de la información contenida.
Gracias.
-----------------------------
This e-mail message and any attached files are intended SOLELY for the addressee/s identified herein. It may contain CONFIDENTIAL and/or LEGALLY PRIVILEGED information and may not necessarily represent the opinion of Aracil Informática SL. If you receive this message in ERROR, please immediately notify the sender and DELETE it since you ARE NOT AUTHORIZED to use, disclose, distribute, print or copy all or part of the contained information.
Thank you.
-----------------------------