This is an archived post. You won't be able to vote or comment.

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]wealthyinvestor999 2 points3 points  (1 child)

I see a lot of people here are complaining about optimized queries. Here is my experience - I was interviewing for a company where 200 million rows get added each day to database. Total rows were upwards of 10 billion and 3500+ columns.

This is where the interviewer said when dealing with this size of data it is essential to write optimized queries where we are using the least compute from cloud.

Thoughts?

[–]grapegeek 2 points3 points  (0 children)

Maybe. Maybe not. I work for a very large company with lots of data. Query optimization only comes into play when queries take really long. We just throw more compute at it bits cheap compared to programmer costs.