Subject Re: RE: [firebird-support] Re: Slow query with 2 joins @L
Author Mark Rotteveel
> This will prevent the use of IDX_/F13/OidwbfyhwFbjRjfng== (by the way,
> I've never seen this kind of index naming before)

I have seen something similar (although with more human readable information) in a system that was developed with long names (eg FK_<TABLE>_<FIELD>_<DESTINATION_TABLE>_<FIELD>). When they went to support Oracle they truncated the names if the name was long and added a hash for the full name, so they would be able to keep their persistence / database abstraction layer as is and leave the translation between the full name and short name to the database specific strategy.

Mark
--
Preisknaller: GMX DSL Flatrate für nur 16,99 Euro/mtl.!
http://portal.gmx.net/de/go/dsl02