Subject | Re: RE: [firebird-support] Re: Slow query with 2 joins @L |
---|---|
Author | Mark Rotteveel |
Post date | 2010-01-19T08:27:27Z |
> This will prevent the use of IDX_/F13/OidwbfyhwFbjRjfng== (by the way,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.
> I've never seen this kind of index naming before)
Mark
--
Preisknaller: GMX DSL Flatrate für nur 16,99 Euro/mtl.!
http://portal.gmx.net/de/go/dsl02