No, I don’t think so. But it is does change our profession and have important implications for software engineers using (not managing) MySQL.
Yes, It turns out that you can specify two indexes in a table hint: SELECT Id, Reputation FROM dbo.Users WITH (INDEX (IX_Reputation, PK_Users_Id)) WHERE Reputation > 1000 And SQL Server obeys. It uses both indexes even though the nonclustered index IX_Reputation is covering: But Why? I think this is a solution looking for a problem. […]
The post You Can Specify Two Indexes In Table Hint? first appeared on Michael J. Swart.This is an external post of mine. Click here if you are not redirected.
Using the right triangle above draw a vertical line separating the area of the triangle in to two parts with the same area. The triangle on the left is 70.7% of the width of the original triangle. Cumulative Storage Costs Think of this another way. The triangle above is a graph of the amount of […]
The post The Tyranny Of Cumulative Costs (Save and Forget Build Up) first appeared on Michael J. Swart.