Main public logs

Combined display of all available logs of PiRho Knowledgebase. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

• 14:09, 5 July 2026 Dex talk contribs created page How Database Queries Really Work (Created page with "'''Summary:''' A practical explanation of how database engines locate, filter, and return information. Rather than focusing on SQL syntax, this article explores what happens inside a database when a query is executed, from simple record scanning through to indexes, query planners, and modern optimisation techniques. == Context == === The Natural Assumption === Why most people imagine databases simply reading every record. === The Sieve Analogy === Understanding querie...")