CodingForums.com - View Single Post

sitechooser · 03-07-2013, 10:21 PM

Magic!

I ran the query on an 80MB table and it returned in 6.5 minutes. I then made the column concerned an index, ran the same query and it returned in 7.6 seconds! Bit of a difference

Thanks a million for your help, got a critical meeting tomorrow morning and you'll make me look like superman.

03-07-2013, 10:21 PM	PM User \| #6
sitechooser New Coder Join Date: Jan 2013 Posts: 16 Thanks: 6 Thanked 0 Times in 0 Posts	Magic! I ran the query on an 80MB table and it returned in 6.5 minutes. I then made the column concerned an index, ran the same query and it returned in 7.6 seconds! Bit of a difference Thanks a million for your help, got a critical meeting tomorrow morning and you'll make me look like superman.