Re:Why PostgreSQL doesn't have query hints
by regularfry on Friday February 04, 2011 @01:07PM
(#2180413)
In what was supposed to be its greatest strength a long, long time ago. I don't know that anyone considers SQL to be anything other than a technical detail any more; certainly not to the extent of expecting normals to be able to get what they need out of a database by writing raw queries.
Re:Why PostgreSQL doesn't have query hints
by arohner on Friday February 04, 2011 @01:53PM
(#2180617)
Yes, but that feature still hinders SQL today. If "usability by normals" was dropped as a design requirement, SQL would look a lot more like a normal programming language, and suck a lot less.
Re:Why PostgreSQL doesn't have query hints
by jtbigwoo on Friday February 04, 2011 @01:16PM
(#2180457)
> It was designed to be a declarative language that normals could use.
We may be getting off the query hint topic, but normals can use SQL Server as you've described. They can write queries and get data out, they just can't expect those queries to perform optimally without expertise.
In normal language, you and I have the freedom to convey our thoughts a billion different ways. But only one guy wrote The Sun Also Rises (for example.) Hemingway found the right way to write it.
Except that SQL wasn't designed as a programming language. It was designed to be a declarative language that normals could use.
In a normal language, you have the freedom to express an algorithm in a billion different ways. You're expected to find the right way to write it. That SQL falls down here is a fundamental flaw in what was supposed to be it's greatest strength.