Query Optimization

Query optimization

Query optimization is a feature in databases that determines the most efficient way to execute a given query by considering different query plans. Users cannot directly access the query optimizer, but some database engines allow hints to guide it. The purpose of query optimization is to find the fastest way to process a query, even though finding the exact optimal plan is often complex and time-consuming.

4 courses cover this concept

15-415/615 Database Applications

Carnegie Mellon University

Fall 2016

This course introduces databases, data models, SQL, database design, query optimization, indexing, and transaction management. It aims to impart understanding of when and how to use database management systems. The course is heavily based on the textbook "Database Management Systems" by Raghu Ramakrishnan and Johannes Gehrke.

No concepts data

+ 20 more concepts

CS 145 Data Management and Data Systems

Stanford University

Fall 2022

This course primarily focuses on the utilization of databases in applications, scaling for large datasets, and effective data systems design. It explores relational data models, SQL, and schema design, concluding with a hands-on SQL+Python project. The course requires CS 103 and CS 107 or equivalent as prerequisites.

No concepts data

+ 17 more concepts

CS 186 Introduction to Database Systems

UC Berkeley

Spring 2023

This project-heavy course covers access methods, data models, query languages, database services, and interfaces. It introduces transaction processing and requires CS 61A, CS 61B, and CS 61C as prerequisites/corequisites. It suggests proficiency in Java for project work.

No concepts data

+ 23 more concepts

CS 245 Principles of Data-Intensive Systems

Stanford University

Winter 2022

This course delves into the architecture of modern data storage and processing systems, including databases, cluster computing, and machine learning systems. It covers database architecture, query optimization, transaction management, and parallel processing. CS 145 and CS 161, or equivalent, are expected as prerequisites.

No concepts data

+ 13 more concepts