3 ms·
Some databases really do loose their mind when the query contains many tables. Sybase was particularly a pain and pretty much required breaking up big queries.
by protomyth 15y ago
Some databases really do loose their mind when the query contains many tables. Sybase was particularly a pain and pretty much required breaking up big queries. Sybase's optimizer for version 12.5 and earlier (cannot speak after that) often required forcing indexes and plans in stored procedures.