4 ms·
Sybase has not kept their end up to what Microsoft has been pushing in SQL Server. Transact-SQL is nicer on SQL Server and the last time I used Sybase the quer
by protomyth 11y ago
Sybase has not kept their end up to what Microsoft has been pushing in SQL Server. Transact-SQL is nicer on SQL Server and the last time I used Sybase the query planner was problematic to the point of needed to force loads of indexes.
- yread 11y agoI second that, we had to run a medium sized application on FusionIO cards because Sybase was just terrible at query optimization
- protomyth 11y agoWe did a lot of monitoring and index forcing. We queried the system tables and go the current query plan for the statements running. We were already on one of the biggest boxes HP built (Superdome) with some fun fast storage for the db.