|Subject||RE: [firebird-support] Differences between dialect 1 and 3|
> Today I convert a database that was build with dialect 1 and i createread all about it here
> a empty database with the same strcutre and same definitions of all,
> but with dialect 3. and i realize a data pump, all is ok, without
> But i notice something:
> 1: with dialect 3 the primary keys, are created index, but now are
> with names more friendly, by example pk_article, and are easier of use
> with the plan. Here the only difference was that use names friendly.
> 2: with the foreign keys, in dialect 1 it create index for them, with
> names unfriendly, but create them. but with dialect 3 i can't find them.
> i gues donesn't exist, and if one want them, need create explicitly.
> Why now aren't created the index for foreing key?, doesn't are useful
> for speedy the joins?.
> Where i can find more information about the differences between
> version 1 and 3?
> Thank's in advance
I don't know what tool you used to re-create your db, but the creation of
indexes is completely up to you other than the ones created for you when you
create primary keys and constraints. In fact - watch that you don't create
duplicate indexes because it could degrade performance.
I also don't know what tool you are using to see what indexes are actually
present so I can't say what mistake you might be making there either.