Hello Set, Actually, the problem isn't with FK_dettbl, but with the A Natural. In a Master detail relationship with 450K+ rows in the master and 800K+ rows in the detail, that "natural" is a killer.
Thanks Again
andrew_s_...@yahoo.com [firebird-support] Tue, 07 Apr 2015 13:16:29 -0700
Hello Set, Actually, the problem isn't with FK_dettbl, but with the A Natural. In a Master detail relationship with 450K+ rows in the master and 800K+ rows in the detail, that "natural" is a killer.
Thanks Again