letnaturebe·Aug 3Sort는 LIMIT을 무시한다 — 목록 조회 37초 버그 잡기주문 목록 조회가 37초 걸린다는 제보를 받았다. 페이지당 20건 보여주는 화면인데, 특정 판매자가 조회하면 너무 느리다고 했다.
InDevOps.devbyLorenzo Uriel·Jul 21DMVs You Need to Master (with Use Cases)Your database knows exactly what is wrong with it. It has been collecting the evidence this whole time. You just never asked.
InDevOps.devbyLorenzo Uriel·Jul 14Improve Queries with Query Execution PlanI want to teach you how to read this yellow table above in this article. What means all these numbers and metrics.
InDevOps.devbyLorenzo Uriel·Jul 10SQL Server ArchitectureThe SQL Server architecture consists of three main components!
Manikanta Bollapragada·Jun 510 Snowflake SQL Tricks That Instantly Improve Query PerformanceIf your Snowflake queries are becoming slower as data grows, you are not alone.
Rahul Hariharan·Dec 14, 2025Optimizing Your (Super Basic) SQLIn the world of software engineering, SQL is often a mechanism to retrieve data — a means to an end. The prevailing mindset is often, “If…
Emirhan Ergün·Nov 12, 2025Oracle’da Hint ve SQL Tuning’i AnlamakSQL sorgusu yazıp Oracle veritabanına sorguyu attığınızda arkaplanda ne olduğunu hiç düşündünüz mü? Veritabanı sorgunuzu olduğu gibi…
Abirami Ramachandran·Oct 27, 2025How “Create Index” and “Create Partition” Order Affects Performance in Oracle DatabaseWhen optimizing large Oracle tables, two of the most important tools in your database tuning toolkit are indexes and partitions.
