Connor McDonald writes that It’s just bad code or bad design … most of the time for Oracle performance problems. 489 more words
Tags » SQL Performance
In the last post we looked at using the STATISTICS IO and STATISTICS TIME commands to measure query performance.
If you’ve started using these, you may notice that once you start to troubleshoot longer scripts or stored procedures that reference lots of tables or have multiple queries, you start getting lots of output. 995 more words
Since SQL 2012, Microsoft enhancing the capabilities of column store indexes that can dramatically enhance the performance of SQL queries. You may ask, what is column store indexes & how it is different than traditional row store index. 622 more words
The Difficulty of Tuning Queries Over a Database Link - Or How I Learned to Stop Worrying and Love the DUAL@LINK Table
A large-ish customer in banking (largest tables on that particular system: ~1 billion rows) once decided to separate the OLTP database from the “log database” in order to better use resources and prevent contention on some tables, as the append-only log database is used heavily for analytic querying of all sorts. 1,963 more words