Reputation
20,000
Top tag
Next privilege 25,000 Rep.
Access to site analytics
Badges
4 37 71
Newest
 index
Impact
~1.5m people reached

Apr
24
comment The definitive fastest radius search query with Postgis 2.0
Check the execution plans. Also read this: wiki.postgresql.org/wiki/Slow_Query_Questions then edit your question and add the missing information
Apr
24
revised The definitive fastest radius search query with Postgis 2.0
deleted 25 characters in body
Apr
24
revised Why did a query change its execution plan and how to anticipate the change?
edited tags
Apr
22
revised Query the last records by date, where condition is true
added 26 characters in body; edited tags
Apr
22
comment Oracle not able to add Default value in PL/SQL
@BriteSponge: that's what I was referring to with "alternative ways"
Apr
22
revised Log Shipping Backup Job Stuck at In Progress for several days
edited tags
Apr
22
answered Oracle not able to add Default value in PL/SQL
Apr
22
revised Single sql query to get the transpose of a matrix
edited tags
Apr
21
revised SQL Server MIRRORING - FAIL ON SECONDARY
SQL is a query language, not a database product
Apr
21
revised Design question
edited tags
Apr
21
comment Get multiple columns from a select subquery
cross apply is available in Postgres starting with 9.3 (released in 2013) but they chose to adhere to the SQL standard and use the standard lateral operator. In your second query replace left join with left join lateral
Apr
21
revised Tomcat7 JDBC connection pool -> Connection has been abandoned
edited tags
Apr
20
revised Start, stop, configure PostgreSQL through Mac terminal
It's Postgres not Postgre
Apr
20
revised Informix help - SQL DBA
every relational database is a "SQL database"
Apr
19
revised Improving query performance involving similarity and full-text search
added 85 characters in body
Apr
18
comment How do I find the day of week of a date-time field in postgres?
TIMESTAMP date is invalid syntax. If you have a column named date remove timestamp. If you have a column named timestamp remove date (another good example why timestamp or date are horrible names for columns)
Apr
18
answered Why does my PostgreSQL query cost so much when I tack on an additional group-by?
Apr
17
comment Does Oracle 11g support CREATE ASSERTION?
Actually there is no DBMS that supports assertions
Apr
17
revised Does Oracle 11g support CREATE ASSERTION?
edited title
Apr
16
revised How can I represent discrete ages in a relational database?
deleted 2 characters in body