User David Aldridge

1 vote

Accepted

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

answered Apr 5, 2022 at 13:23

1 vote

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

answered Mar 12, 2022 at 21:27

2 votes

Duplicate Conditions in PostgreSQL Query

answered Mar 11, 2022 at 8:32

2 votes

Achieving best practice schema and permissions management on PostgreSQL

answered Nov 22, 2021 at 8:58

3 votes

Accepted

Deleting large amount of data in ORACLE

answered Apr 6, 2017 at 13:30

4 votes

Accepted

Efficiently store time based data

answered Apr 2, 2017 at 16:38

0 votes

Help in Performance Tuning Required

answered Dec 9, 2016 at 11:48

0 votes

sqlldr running slow after indexes created

answered Nov 13, 2016 at 22:34

3 votes

Data Warehouse Design and Double Dipping

answered Nov 7, 2016 at 17:45

4 votes

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

answered Apr 6, 2015 at 9:53

0 votes

Access Oracle GTT table data from another session?

answered Mar 2, 2015 at 23:42

0 votes

Oracle: terrible execution times from virtual application server

answered Nov 18, 2013 at 8:23

3 votes

Oracle Equivalent of PostgreSQL CLUSTER

answered Sep 25, 2013 at 9:14

12 votes

Is Oracle free to download?

answered Sep 18, 2013 at 15:49

3 votes

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

answered Sep 17, 2013 at 6:37

3 votes

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

answered Sep 9, 2013 at 10:54

0 votes

Assign values with the := operator

answered Sep 9, 2013 at 10:49

4 votes

Best cloud platform for PostgreSQL

answered Aug 28, 2013 at 13:09

2 votes

Example optimisic offline lock in SQL/PL?

answered Aug 15, 2013 at 12:40

0 votes

Oracle impdp - Importing file from remote server

answered Aug 13, 2013 at 20:13

1 vote

Unable to connect oracle as sysdba tables have been dropped

answered Jul 23, 2013 at 17:48

1 vote

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

answered Jul 22, 2013 at 12:28

0 votes

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

answered Jul 16, 2013 at 8:23

1 vote

to_number, ORA-01722: invalid number error

answered Jul 15, 2013 at 8:31

5 votes

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

answered Jul 8, 2013 at 23:40

19 votes

Accepted

Partitioning vs Indexes

answered Jul 8, 2013 at 23:04

1 vote

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

answered Jul 2, 2013 at 9:42

3 votes

How to manage constants within an Oracle Database

answered Jun 29, 2013 at 16:17

1 vote

How to keep an Oracle 11g instance lean?

answered Jun 18, 2013 at 10:30

2 votes

What happens when we create index

answered Jun 16, 2013 at 11:01

Stack Exchange Network

64 Answers

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

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

Duplicate Conditions in PostgreSQL Query

Achieving best practice schema and permissions management on PostgreSQL

Deleting large amount of data in ORACLE

Efficiently store time based data

Help in Performance Tuning Required

sqlldr running slow after indexes created

Data Warehouse Design and Double Dipping

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

Access Oracle GTT table data from another session?

Oracle: terrible execution times from virtual application server

Oracle Equivalent of PostgreSQL CLUSTER

Is Oracle free to download?

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

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

Assign values with the := operator

Best cloud platform for PostgreSQL

Example optimisic offline lock in SQL/PL?

Oracle impdp - Importing file from remote server

Unable to connect oracle as sysdba tables have been dropped

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

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

to_number, ORA-01722: invalid number error

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

Partitioning vs Indexes

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

How to manage constants within an Oracle Database

How to keep an Oracle 11g instance lean?

What happens when we create index