User Andrew Sayer

1 vote

Insert query in Orcale database - not showing the row in a table

answered Jul 11, 2021 at 11:34

1 vote

Is DB_FILE_NAME_CONVERT just needed when in the same machine?

answered Jul 11, 2021 at 16:24

1 vote

AD login in SQL can access all the databases

answered Jul 3, 2021 at 10:06

1 vote

Quering millions of rows is still slow with index and a materialized view

answered Jul 23, 2021 at 17:46

1 vote

How can I achieve predicate pushdown in my view

answered Jul 24, 2021 at 21:14

1 vote

adding the right index to a table in a MySQL Database

answered Aug 2, 2021 at 18:54

1 vote

Oracle Update Left Join

answered Aug 6, 2021 at 20:36

1 vote

insert on table being unnaturally slow

answered Aug 16, 2021 at 19:54

1 vote

Oracle SELECT FOR UPDATE on a single row with ORDER BY: ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc

answered Oct 27, 2023 at 17:00

1 vote

Wrapping fast query into a subquery with count(*) makes it extremely slow

answered Oct 6, 2022 at 21:29

1 vote

Accepted

Intended use case for virtual columns with function-based index?

answered May 25, 2022 at 16:50

1 vote

Optimal procedure for partitioning with auto-increment PK as boundary value

answered Jun 22, 2022 at 7:12

1 vote

How to optimize table for arbitrary user-made queries?

answered Jun 5, 2022 at 16:52

1 vote

Accepted

Query with EXISTS-subquery taking about 280 ms in 80 % of cases, and less than 1 ms in 20 % of cases

answered May 9, 2022 at 11:27

1 vote

Could MySQL perform better on a 10GB network storage with raid vs local HDD?

answered May 16, 2022 at 6:45

1 vote

Accepted

Rotate passwords with zero down time

answered May 17, 2022 at 5:50

0 votes

SQL Syntax Error when using Group by conditional expression

answered May 17, 2022 at 7:30

0 votes

Should I be using a non-clustered primary key on multiple columns?

answered May 12, 2022 at 11:49

0 votes

Is it possible to create/update a dev version of production SQL server using disk move?

answered May 7, 2022 at 12:49

0 votes

Access Oracle Database remotely via DBeaver

answered Jun 21, 2022 at 6:51

0 votes

I tried to optimize my PG. The results are decent. Did I do wrong somewhere? Can I do better?

answered Oct 27, 2022 at 19:32

0 votes

Oracle Edition-based redefinition(EBR) use case

answered Oct 28, 2022 at 19:32

0 votes

Why is to_char used when doing a divide by 0 in Oracle based SQLi?

answered Jan 23, 2023 at 15:45

0 votes

Accepted

Different performance of SQL Server instances on same server

answered Jan 30, 2023 at 7:00

0 votes

Why is an oracle query executed multiple times?

answered Jun 2, 2023 at 6:28

0 votes

Oracle Execution Plan - Outline Question

answered Jun 29, 2021 at 21:34

0 votes

How to fetch latest rows from oracle db

answered Jul 22, 2021 at 18:37

0 votes

Get nested procedure and sql execution oracle

answered Feb 8, 2021 at 11:20

0 votes

Optimal Indexing Strategy

answered Dec 31, 2020 at 10:18

0 votes

Accepted

How to not include the query in sqlcmd output file

answered Mar 15, 2021 at 18:08

Stack Exchange Network

99 Answers

Insert query in Orcale database - not showing the row in a table

Is DB_FILE_NAME_CONVERT just needed when in the same machine?

AD login in SQL can access all the databases

Quering millions of rows is still slow with index and a materialized view

How can I achieve predicate pushdown in my view

adding the right index to a table in a MySQL Database

Oracle Update Left Join

insert on table being unnaturally slow

Oracle SELECT FOR UPDATE on a single row with ORDER BY: ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc

Wrapping fast query into a subquery with count(*) makes it extremely slow

Intended use case for virtual columns with function-based index?

Optimal procedure for partitioning with auto-increment PK as boundary value

How to optimize table for arbitrary user-made queries?

Query with EXISTS-subquery taking about 280 ms in 80 % of cases, and less than 1 ms in 20 % of cases

Could MySQL perform better on a 10GB network storage with raid vs local HDD?

Rotate passwords with zero down time

SQL Syntax Error when using Group by conditional expression

Should I be using a non-clustered primary key on multiple columns?

Is it possible to create/update a dev version of production SQL server using disk move?

Access Oracle Database remotely via DBeaver

I tried to optimize my PG. The results are decent. Did I do wrong somewhere? Can I do better?

Oracle Edition-based redefinition(EBR) use case

Why is to_char used when doing a divide by 0 in Oracle based SQLi?

Different performance of SQL Server instances on same server

Why is an oracle query executed multiple times?

Oracle Execution Plan - Outline Question

How to fetch latest rows from oracle db

Get nested procedure and sql execution oracle

Optimal Indexing Strategy

How to not include the query in sqlcmd output file