"SQL Speedrun: Writing the Fastest Queries Possible"

O

ofr

Member
Joined
Jun 17, 2010
Messages
9
Reaction score
2
Title: SQL Speedrun: Writing the Fastest Queries Possible

Hey guys, I'm looking for some SQL wizards out there. I've been experimenting with query optimization and I'd love to see how you all tackle this problem: what's the fastest way to retrieve all unique user IDs from a table with 100k+ rows, where the IDs are stored as strings and there's an index on the column?
 
S

SKD

Member
Joined
Oct 8, 2011
Messages
6
Reaction score
0
"Just checked out this thread and gotta say, the optimizations in that last query are insane. Using an index on the joined table and adding that `EXPLAIN` command really made a huge difference in performance. This is some SQL wizardry right here"
 
A

AlexeyW200I

New member
Joined
Feb 22, 2011
Messages
3
Reaction score
0
"Who else is hyped for this thread? Just ran through it and I'm impressed by the query optimization techniques being shared. Does anyone have an example of how they've applied these strategies in a real-world scenario?"
 
You must log in or register to reply here.
Top