Andreas Pflug wrote: > Well it's not really hard, just some things to think of. And the longer > I think about it, and looking at your example, I'd say people analyzing > a query should know a little what pgsql is doing, e.g. that unique and > primary constraints include an index. Thus I tend to say we'll stay with > what we got now. I can't completely agree with you. I use only PostgreSQL, but I used to help my colleague working with Oracle (he was a novice), and I looked at his result of EXPLAIN (it was different from what PostgreSQL gives, but quite clear). I am not sure that in every database engine PRIMARY KEY constraint is implemented using index. So you give some astonishment to people not familiar with PostgreSQL but familiar with some other DBMS and able to understand result of EXPLAIN.
-- Constantin Stefanov ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
