Skip to content
Tagged articles

Generated Columns

6 articles · Page 1 of 1
java1234
java1234
Oct 9, 2026 · Databases

PostgreSQL 18.6 Deep Dive: Async I/O, Skip Scan, UUIDv7 & More

PostgreSQL 18.6 introduces async I/O with io_uring support, skip scan for composite indexes, time-ordered UUIDv7, virtual generated columns, OAuth authentication, RETURNING old/new values, and critical security fixes for logical decoding and pgcrypto.

GIN IndexGenerated ColumnsOAuth
0 likes · 15 min read
PostgreSQL 18.6 Deep Dive: Async I/O, Skip Scan, UUIDv7 & More
Ray's Galactic Tech
Ray's Galactic Tech
Dec 15, 2025 · Databases

10 Advanced MySQL Techniques to Write Faster, Cleaner SQL

Discover ten powerful MySQL features—including CTEs, window functions, conditional aggregation, JSON handling, generated columns, and UPSERT tricks—illustrated with real‑world examples and performance tips, so you can write SQL that is more efficient, maintainable, and production‑ready.

CTEGenerated ColumnsJSON
0 likes · 15 min read
10 Advanced MySQL Techniques to Write Faster, Cleaner SQL
Selected Java Interview Questions
Selected Java Interview Questions
Dec 5, 2025 · Databases

Unlock MySQL 8.0’s Hidden Optimization Tricks to Supercharge Your Queries

Discover eight powerful, lesser‑known MySQL 8.0 features—including window functions, descending indexes, generated columns, invisible indexes, hints, resource groups, LATERAL JOIN, and multi‑valued JSON indexes—that can dramatically improve query performance, simplify code, and give you an edge in interviews and production environments.

Generated ColumnsJSONLATERAL JOIN
0 likes · 12 min read
Unlock MySQL 8.0’s Hidden Optimization Tricks to Supercharge Your Queries
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 3, 2021 · Databases

Understanding MySQL Functional (Expression) Indexes

The article explains MySQL functional (expression) indexes, how they are implemented via generated columns, demonstrates their creation and performance benefits for datetime and JSON fields, compares them with prefix indexes, and offers guidance for older MySQL versions.

Generated ColumnsJSON Indexfunctional index
0 likes · 12 min read
Understanding MySQL Functional (Expression) Indexes
Java High-Performance Architecture
Java High-Performance Architecture
Jun 20, 2016 · Databases

Boost MySQL Query Performance with Generated Virtual Columns

MySQL 5.7 introduces generated (virtual) columns, allowing you to store computed values such as day‑of‑week without extra storage, enabling indexed queries that bypass function‑based limitations, improving read performance while avoiding the write‑time overhead and redundancy of manual columns.

Generated ColumnsIndexingMySQL
0 likes · 4 min read
Boost MySQL Query Performance with Generated Virtual Columns