User Andrew Sayer

27 votes

How do others know what is delivery address and invoice address if they are in the same table?

answered Jan 31, 2021 at 16:41

12 votes

Accepted

Optimize MYSQL Select query in large table

answered May 1, 2022 at 12:24

9 votes

Select a row from one table, if it doesn't exist, select from another table

answered Feb 13, 2021 at 9:40

8 votes

Accepted

What does this mean "index is also maintained in the transaction log"?

answered Sep 29, 2021 at 5:57

7 votes

Accepted

Restore database of 90GB to computer of only 100GB

answered Jul 3, 2021 at 19:18

6 votes

Accepted

Highest cost section in Actual Execution Plan doesn't show any logical reads?

answered Feb 1, 2021 at 21:17

5 votes

Fixing a Mistake in SQL

answered Apr 30, 2021 at 6:05

5 votes

What if we do not use MAX function

answered Nov 9, 2022 at 7:11

4 votes

Accepted

In my query plan - multiple nodes say that their cost is 100%

answered Jun 6, 2022 at 16:09

4 votes

Accepted

Reduce rows read by the database engine for this aggregate query

answered Oct 20, 2021 at 6:27

4 votes

PostgreSQL 9.6 - ORDER BY timestamp DESC LIMIT 10 is extremely slow even with index

answered Mar 31, 2022 at 22:15

3 votes

Indexing on one column slows down query, but indexing on two speeds it up

answered Jan 26, 2022 at 22:03

3 votes

How does this ORDER BY question makes sense?

answered Mar 1, 2022 at 13:00

3 votes

From spinners to SSD (SQL Database)

answered Mar 24, 2022 at 12:36

3 votes

slow mysql query need help

answered May 4, 2022 at 12:31

3 votes

Need help tuning a complicated query

answered Apr 22, 2022 at 23:26

3 votes

Accepted

Problem with Oracle Job Scheduling

answered Apr 26, 2022 at 9:36

3 votes

Accepted

Oracle simple count(*) SQL query takes "forever"

answered Oct 20, 2021 at 18:03

3 votes

Accepted

Does trailing wildcard use index? (where column like 'value%')

answered Nov 6, 2021 at 9:08

3 votes

Index Not Being Utilized in Plan by SQL Server

answered Nov 12, 2021 at 19:29

3 votes

Truncate huge table of 6.4TB - Oracle

answered Nov 26, 2021 at 20:47

3 votes

Accepted

MariaDB 0th day?

answered Oct 2, 2021 at 20:05

3 votes

Oracle alertlog with WARNING: too many parse errors

answered Sep 1, 2021 at 10:11

3 votes

is it safe to compress backups for databases with TDE enabled?

answered Feb 17, 2021 at 12:47

3 votes

weird behaviour of NVL(<Column_name>,Sequence.nextval) when the colummn has data?

answered Jun 29, 2021 at 9:09

3 votes

Accepted

Oracle How to get Execution Plan for SQL executed inside of PLSQL?

answered May 26, 2022 at 17:15

3 votes

Accepted

Why is the optimizer not using the clustering index on my table?

answered May 12, 2022 at 11:30

2 votes

Accepted

Azure SQL Average lock wait time logs?

answered May 6, 2022 at 9:59

2 votes

New Index creation can benefit from existing Index

answered Apr 22, 2022 at 18:11

2 votes

Accepted

Parallel and faster evaluation of SELECTing boolean comparing count

answered Sep 10, 2022 at 8:36

Stack Exchange Network

99 Answers

How do others know what is delivery address and invoice address if they are in the same table?

Optimize MYSQL Select query in large table

Select a row from one table, if it doesn't exist, select from another table

What does this mean "index is also maintained in the transaction log"?

Restore database of 90GB to computer of only 100GB

Highest cost section in Actual Execution Plan doesn't show any logical reads?

Fixing a Mistake in SQL

What if we do not use MAX function

In my query plan - multiple nodes say that their cost is 100%

Reduce rows read by the database engine for this aggregate query

PostgreSQL 9.6 - ORDER BY timestamp DESC LIMIT 10 is extremely slow even with index

Indexing on one column slows down query, but indexing on two speeds it up

How does this ORDER BY question makes sense?

From spinners to SSD (SQL Database)

slow mysql query need help

Need help tuning a complicated query

Problem with Oracle Job Scheduling

Oracle simple count(*) SQL query takes "forever"

Does trailing wildcard use index? (where column like 'value%')

Index Not Being Utilized in Plan by SQL Server

Truncate huge table of 6.4TB - Oracle

MariaDB 0th day?

Oracle alertlog with WARNING: too many parse errors

is it safe to compress backups for databases with TDE enabled?

weird behaviour of NVL(<Column_name>,Sequence.nextval) when the colummn has data?

Oracle How to get Execution Plan for SQL executed inside of PLSQL?

Why is the optimizer not using the clustering index on my table?

Azure SQL Average lock wait time logs?

New Index creation can benefit from existing Index

Parallel and faster evaluation of SELECTing boolean comparing count