Posts Tagged ‘SQL’

Advanced SQL database administration: Indices

Posted by: Jim
Date posted: 27/01/2010
Advanced SQL database administration: Indices

To start with, I’m going to describe the worst-case scenario, and it’s pretty simple: imagine you have a million rows which are in no particular order as far as the column you’re looking for is concerned. Even if reading each row is very quick (say 1 ms or a thousandth of a second)…