undefined | Better HN

Skip to content

Top Best Ask Show New Jobs

0 pointsredis_mlc6y ago0 comments

> DBAs becoming engineers

Excuse me. Most of the top DBAs in Silicon Valley are former C programmers who probably are better programmers than you.

I wish programmers would get over themselves. I've met CTOs who didn't know EXPLAIN. So who's the real engineer?

0 comments

4 comments · 1 top-level

google2341236y ago· 3 in thread

What is EXPLAIN?

shagie6y ago

A tool for looking at how a query is run and where it may be slow.

https://docs.oracle.com/cd/B19306_01/server.102/b14211/ex_pl...

https://dev.mysql.com/doc/refman/5.7/en/explain.html

https://www.postgresql.org/docs/current/sql-explain.html

https://docs.microsoft.com/en-us/sql/t-sql/queries/explain-t...

teddyh6y ago

It’s not in standard SQL, but is present in most SQL implementations:

https://www.postgresql.org/docs/current/sql-explain.html

https://www.sqlite.org/lang_explain.html

https://mariadb.com/kb/en/explain/

SQL command to show how a database engine will execute a given query. I wouldn't necessarily expect a CTO to know about it, to be honest, unless their background was somewhat database-y.

j / k navigate · click thread line to collapse