Alexander Gräf wrote:

> ""Carsten Schäfer"" <ca_schaefer@...> schrieb im Newsbeitrag
> news:<000c01c4d2ce$f4e857e0$0b00a8c0@zander>...
>>
>> Hi,
>> I'm using Firebird 1.5.2 RC3.
>> I have 2 tables (definitions at the end of this message):
>
> Those table definitions are quite confusing. A first step in
> understanding would be to name the indices/constraints. This way, you
> can see which indices the query plan optimizer uses. The table layout
> looks like you could normalize the whole thing, to make queries
> faster.

In my table definition all indices/constraints are named.
How can i name the indice Firebird creates for primary key and foreign keys
?
I've added some explanations to my new post.

mfg
Carsten