DB OPTimize

Tag Archive: add index

Thinking of adding a new index? Tune SQL’s text before

Creating an index can certainly do marvellous things to SQLs. Even after all those years in the field, it is still always thrilling for me to witness¬†huge performance improvement seen after applying a suitable index to an unturned query. The performance gain is simply spectacular and the notices slump in resource consumption this query is taking (I/O, CPU, etc) is immediate. (more…)