> Thank's :), i was a little confused, i used the ibwebadmin and i must
> correct mi first aseveration.
>
> the names that are given to the indexes are the same used in the
> definition of the constraints.
>
>
> is just that ibwebadmin some times doesn't display all records that
> supposedly must show; and with the database with dialect 3 it showme
> some of the indexes that exist ( all the indexes of the PK's) in tab
> of accesories. Meanwhile with dialect 1 doesn't do that.
>
>
> When i read your post then i decide use the isql directly, and yes,
> the same index are created in both dialects.
>
>
> But i must say that in the ddl created by ibwebadmin and used for
> create the databases with the isql doesn't exist definition of
> indexes, just of the constraints for foreing keys and primary keys,
> and indices are created automatically. :)
>
> check this:
>
> select RDB$INDEX_NAME, RDB$FOREING_KEY from RDB$INDICES;
>
> and i'm sure that you will find index for that constraints, are
> created automatically.
>
>
> But thank's i was confused, and your reply make me that i check the
> things more carefully.
>

Yes - these indexes are created automatically. So don't make the mistake of
creating them yourself as well - then you will have duplicate indexes which
are not good for performance.
Alan