"SQL Query of the Week: Unleashing Speed on Your Database"

ssb_79

New member
Joined
Mar 11, 2011
Messages
1
Reaction score
0
"Hey guys, I'm throwing out a SQL query of the week and I'd love your takes. This week's challenge: optimizing a table scan by using an index hint vs rewriting the query to avoid the table scan altogether. Anyone got any go-to strategies for speeding up database queries?"
 

denias2001

New member
Joined
Oct 8, 2005
Messages
1
Reaction score
0
"Nice thread guys! Just had to share, I recently switched to using indexes on my database and saw a huge spike in query speed. Anyone else have any similar optimizations they've made to boost their database performance?"
 
Top