David Aldridge's user avatar
David Aldridge's user avatar
David Aldridge's user avatar
David Aldridge
  • Member for 11 years, 1 month
  • Last seen more than 1 year ago
  • Haddenham, United Kingdom
1 vote
Accepted

Query to update one column based on the amount of another column

1 vote

Why does an index on the join predicate does not improve the performance of a hash join?

2 votes

Duplicate Conditions in PostgreSQL Query

2 votes

Achieving best practice schema and permissions management on PostgreSQL

3 votes
Accepted

Deleting large amount of data in ORACLE

4 votes
Accepted

Efficiently store time based data

18 votes

Why are constraints applied in the database rather than the code?

0 votes

Help in Performance Tuning Required

0 votes

sqlldr running slow after indexes created

3 votes

Data Warehouse Design and Double Dipping

4 votes

Oracle: finding rows without children in a table with a foreign key?

0 votes

Access Oracle GTT table data from another session?

7 votes
Accepted

How to retrieve disk spaces by removing tables from tablespaces in Oracle 10g?

0 votes

Oracle: terrible execution times from virtual application server

3 votes

Oracle Equivalent of PostgreSQL CLUSTER

12 votes

Is Oracle free to download?

3 votes

ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

3 votes

Selecting from a function that returns a sys refcursor or an alternative

0 votes

Assign values with the := operator

4 votes

Best cloud platform for PostgreSQL

2 votes

Example optimisic offline lock in SQL/PL?

0 votes

Oracle impdp - Importing file from remote server

1 vote

Unable to connect oracle as sysdba tables have been dropped

1 vote

Why won't Oracle alter the size of a column that is used for sub partitioning?

0 votes

CONNECT BY using 3 tables(2 DIM and 1 FACT to get the Level and dependencies)

1 vote

to_number, ORA-01722: invalid number error

5 votes

How make convincing case to DBA to use Oracle external tables for 500 MB to 5 GB files?

19 votes
Accepted

Partitioning vs Indexes

1 vote

How would you track DB storage use and then extrapolate it?

3 votes

How to manage constants within an Oracle Database