DEV Community

loading...

Discussion on: Speed up your queries with indexes

Collapse
bengreenberg profile image
Ben Greenberg

This is great! One of the first things I did at my job was create indexes and that dramatically sped up our SSRS queries. It felt like a good low hanging fruit, which unfortunately gets overlooked.

Collapse
helenanders26 profile image
Helen Anderson Author

That’s great to hear. Did you have a friendly DBA to talk it through with?

Collapse
bengreenberg profile image
Ben Greenberg

In this case, I also became a bit of the friendly DBA. It's a small in house team, so everyone does a bit of everything!

Thread Thread
helenanders26 profile image
Helen Anderson Author

I feel like there are a lot of 'accidental DBAs' out there :)

Thread Thread
bengreenberg profile image
Ben Greenberg

That's probably true, and we're all just trying to be extra careful not to drop the database!

Thread Thread
helenanders26 profile image
Helen Anderson Author

Having all that power is a beautiful... and terrifying thing :)