Reputation
14,421
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 26 54
Impact
~826k people reached

Apr
27
comment To split tables is a good idea?
40 Million is not really that large. With proper indexing you probably don't need to partition your table. But if your query is slow, please read this: wiki.postgresql.org/wiki/Slow_Query_Questions and then post the missing information.
Apr
27
revised Searching multiple tables in SQL
edited tags
Apr
27
comment Creating a Developer Schema
Which DBMS are you using? Postgres? Oracle?
Apr
27
revised String or binary data would be truncated
added 2 characters in body
Apr
27
answered String or binary data would be truncated
Apr
27
reviewed Edit String or binary data would be truncated
Apr
27
revised String or binary data would be truncated
formatting
Apr
27
comment JOIN 3 Tables Form Error
Edit your question and add the error message as (formatted) text - don't post screenshots
Apr
23
revised How to join tables without identifiers?
edited tags
Apr
23
comment What are valid usage scenarios for HEAP tables?
use-the-index-luke.com/blog/2014-01/…
Apr
23
revised plsql wiki description
added 47 characters in body
Apr
23
revised plsql wiki excerpt
added 56 characters in body
Apr
23
suggested approved edit on plsql tag wiki
Apr
23
suggested approved edit on plsql tag wiki excerpt
Apr
22
comment PostgreSQL DB freezes with large inserts
Cross post: stackoverflow.com/q/29799104/330315
Apr
22
comment Proper use of extract function?
You can only extract from one column: extract(year from dob). For details see the manual: docs.oracle.com/cd/E11882_01/server.112/e41084/…
Apr
22
comment Tool for browsing JavaDB
db.apache.org/derby/blogs/index.html and wiki.apache.org/db-derby/UsesOfDerby#GUI_Tools
Apr
21
awarded  Notable Question
Apr
21
comment Can this UPDATE be faster with indexes?
@septerr: the main reason the query is faster is the removal of the implicit cross join you created between line_item and itself through the from line_items part. Read the note in the manual regarding this: postgresql.org/docs/current/static/sql-update.html#AEN85302
Apr
21
answered How to use except but excluding a column from the except clause comparison -psql?