Skip to main content
Database Administrators
David Aldridge's user avatar
David Aldridge's user avatar
David Aldridge's user avatar
David Aldridge
  • Member for 11 years, 9 months
  • Last seen more than a month ago
  • Haddenham, United Kingdom
Profile Activity

199 Actions

All Accepts Posts Badges Comments Revisions Reviews Suggestions
awarded
 Popular Question
awarded
 Yearling
comment
Subquery or Inner Join?
The style is a matter of opinion, and I'd avoid them CTEs in earlier versions of PostgreSQL as they are an optimiser fence.
comment
Subquery or Inner Join?
Is there any advantage to this?
answered
Query to update one column based on the amount of another column
comment
Why does an index on the join predicate does not improve the performance of a hash join?
Well BC is talking about Oracle, not postgresql,and is wrong about a lot of things even then.
answered
Why does an index on the join predicate does not improve the performance of a hash join?
answered
Duplicate Conditions in PostgreSQL Query
awarded
 Yearling
answered
Achieving best practice schema and permissions management on PostgreSQL
comment
How do I SHOW TABLES in Oracle Database?
Doesn't SQL Developer already show you a list of tables?
asked
Achieving best practice schema and permissions management on PostgreSQL
awarded
 Yearling
comment
What is the real difference between vacuum and vacuum analyze on Postgresql?
The recommendation from AWS is a minumum of 256 I believe.
awarded
 Yearling
awarded
 Enlightened
awarded
 Nice Answer
awarded
 Yearling
revised
Oracle database 18c – ORA-12541: TNS:no listener
More descriptive title
comment
Save schedules (working hours)
"in each doctors table" ... you don't really have one table per doctor, do you? Having one table for all doctors, with a foreign key to a doctors table would be better.
1
2 3 4 5
…
10