logoalt Hacker News

EvanAndersontoday at 7:55 AM2 repliesview on HN

> Additionally learn stored procedures.

For sure, but have a solid grounding in set theory to go with it.

I've dealt with so many poorly-performing stored procedures that ended up being written as iteration over a CURSOR when they could have been done with sets. Programmers who don't grok set theory reach for iterative constructs which, while they work fine, are an impedance mismatch with SQL.


Replies

clappskitoday at 8:21 AM

At least in that case you can refactor the stored proc to be more performant without pushing application changes.

pjmlptoday at 8:26 AM

Agreed, however that applies to SQL in general.

I have seen DBAs make wonders without changing queries, only by adding the right set of indexes.