Eventually you’ll run into a simple delete instruction that takes minutes (I mean, years!) to get executed. It’s just a hundred-row table, and, still, it takes a lifetime to get the rows deleted. Here’s a small tip: you’re probably missing some indexes. Foreign Keys and their dirty secrets There is a very basic, yet very […]
Advertisement