http://netvouz.com/tag/distinct?feed=rss Bookmarks tagged with "distinct" on Netvouz http://www.databasejournal.com/features/postgresql/article.php/3437821 There is an understanding in the database world that using a 'SELECT DISTINCT' SQL query is not a good idea, because it is essentially getting duplicate rows out of the database and then discarding them. Usually it's better to rearrange the 'WHERE' clause in the query to only get the rows you need. Tom Copeland gives a step-by-step 'case study' of analyzing a query in PostgreSQL and how to ensure that your SQL rewrite is actually paying off. programming > sql postasaurus Tue, 12 Dec 2006 10:12:10 GMT