Using Triggers to Automatically Add Indexes

added by Paul Wheeler
8/8/2014 8:51:33 PM

2 Kicks, 85 Views

Let’s say you’ve got a vendor application that creates tables, loads them, queries them, and drops them all the time. You can’t change the code. The tables involved desperately need an index in order to go faster, and they’re your biggest performance bottleneck. Enter DDL triggers.