56,966 blogs · 4,417,066 posts Claim your blog

Record · corpus.blog/posts/01a087e9-67f6-72df-86c6-28998692d2d4

Reasons why SELECT * is bad for SQL performance

tanelpoder · published 25 November 2020

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at tanelpoder.com Wayback capture

1blogs citing

First cited: 18 Feb 2021
Most recent: 18 Feb 2021
Rank this month: not ranked
Links from this post: 12
Words captured: 5,584

Cited by

Blog

In the post

Date

Reading Update Read at the source ↗

18 Feb 2021

Links from this post

Link

Host

SQL*Net message to client vs SQL*Net more data to client Read at the source ↗

https://tanelpoder.com/psnapper/

tanelpoder.com

https://blogs.oracle.com/opal/sqlplus-12201-adds-new-performance-features

blogs.oracle.com

https://oracle-base.com/articles/misc/join-elimination

oracle-base.com

RAM is the new disk – and how to measure its performance – Part 1 – Introduction Read at the source ↗

https://github.com/tanelpoder/tpt-oracle/blob/master/demos/create_wide_table.sql

github.com

https://tanelpoder.com/snapper/

tanelpoder.com

https://github.com/tanelpoder/tpt-oracle/blob/master/sqlmem.sql

github.com

LOBREAD SQL Trace entry in Oracle 11.2 (and tracing OPI calls with event 10051) Read at the source ↗

https://twitter.com/lukaseder

twitter.com

https://jooq.org

jooq.org

https://blog.jooq.org/many-sql-performance-problems-stem-from-unnecessary-mandatory-work/

blog.jooq.org