A comprehensive guide to SQL query optimization focusing on expressions that defeat database indexes. Covers 20 common anti-patterns with practical solutions for PostgreSQL, MySQL, and SQL Server. Includes examples of sargable vs non-sargable queries, functional indexes, and performance optimization techniques
☆18Aug 24, 2025Updated last year
Alternatives and similar repositories for index_defeating_expressions
Users that are interested in index_defeating_expressions are comparing it to the libraries listed below. We may earn a commission when you buy through links labeled 'Ad' on this page.
Sorting:
- Learning Data Structure and Algorithm By Doing☆20Sep 27, 2025Updated last year
- This project leverages TensorFlow Lite's body segmentation to replace the background in real-time on Android devices. Using deep learning…☆13Jun 2, 2026Updated 4 months ago
- The SEAL-CPU backend is a Reference backend engine for HEBench which is a shared library that implements the required functions specified…☆11Mar 3, 2023Updated 3 years ago
- Incremental optimizations to the N-Body problem in order to evaluate and compare the performance of Python translators in the HPC environ…☆13Apr 2, 2023Updated 3 years ago
- Yet another online judge, built with ASP.NET Core, Angular and Isolate.☆22Mar 7, 2023Updated 3 years ago
- Managed Kubernetes at scale on DigitalOcean • AdDigitalOcean Kubernetes includes the control plane, bandwidth allowance, container registry, automatic updates, and more for free.
- Adds a Doctrine Id generator which uses an ordered UUID in MySQL for extra performance. Uses methods described in Karhik Appigatla's arti…☆10Jun 8, 2015Updated 11 years ago
- Sparse Matrix Factorization (SMF) is a key component in many machine learning problems and there exist a verity a applications in real-w…☆12Jan 25, 2016Updated 10 years ago
- A high-performance, header-only C++ library for image tensor data format conversion, leveraging OpenMP parallel processing for unparallel…☆12Sep 4, 2026Updated last month
- 💾 Optimize Laravel caching with Cachetastic! Cache method results, force refresh, handle errors, and boost app performance effortlessly.☆13Jan 26, 2026Updated 8 months ago
- NWChem TCE CCSD(T) loop-driven kernels for performance optimization experiments☆11Dec 20, 2023Updated 2 years ago
- Sekai Viewer but built with Next, optimized for performance☆11Jan 20, 2023Updated 3 years ago
- My personal dotfiles with automated macOS setup. Features smart installation scripts, Bats testing (bash), performance monitoring, and 2…☆11Oct 1, 2026Updated 2 weeks ago
- This open-source project helps you effortlessly manage your financials, providing accurate insights into your sales, expenses, and profi…☆16Dec 3, 2024Updated last year
- An experimental python library to compile and analyze the cost of any desired composite simulation in real or imaginary time, and with or…☆11Feb 9, 2024Updated 2 years ago
- AI Agents on DigitalOcean Gradient AI Platform • AdBuild production-ready AI agents using customizable tools or access multiple LLMs through a single endpoint. Create custom knowledge bases or connect external data.
- Demo repository for article "Express server, Handlebars & Critical Path Performance Optimization"☆13Jan 12, 2017Updated 9 years ago
- Twiez Optimizer is a powerful, all-in-one utility for Windows that boosts system performance, safely cleans junk files, removes bloatware…☆19Jun 12, 2026Updated 4 months ago
- CRUD Operations in .Net 8☆28Sep 21, 2023Updated 3 years ago
- Reworked SunnyUI for Native AOT. Fixed stability issues when running WinForms in AOT mode with .NET 8/9. Optimized for compatibility and …☆16Aug 7, 2025Updated last year
- Restaurant Management System is a web application built with Next.js and TypeScript. It offers features for restaurant management, includ…☆15May 1, 2025Updated last year
- Repository for running LLMs efficiently on Mac silicon (M1, M2, M3). Features Jupyter notebook for Meta-Llama-3 setup using MLX framework…☆11May 4, 2024Updated 2 years ago
- ☆10Nov 22, 2022Updated 3 years ago
- This guide provides steps to enhance the performance of Windows 10 by removing unnecessary files and services, and optimizing system sett…☆11Sep 1, 2024Updated 2 years ago
- Optimizing loading training data from cloud bucket storage for cloud-based distributed deep learning. Official repository for Quantifying…☆11Jan 1, 2022Updated 4 years ago
- Managed Database hosting by DigitalOcean • AdPostgreSQL, MySQL, MongoDB, Kafka, Valkey, and OpenSearch available. Automatically scale up storage and focus on building your apps.
- A lightweight React hook that automatically manages fade overlays for scrollable containers. Provides smooth gradient transitions at the …☆12Aug 11, 2025Updated last year
- A maintained list of open source Islamic projects, grouped by app types and programming languages☆121Jul 6, 2026Updated 3 months ago
- A SystemVerilog-based simulation and design of a Last Level Cache (LLC) implementing the MESI protocol, featuring Pseudo-LRU replacement,…☆17Mar 8, 2026Updated 7 months ago
- r3conwhale aims to develop a multifunctional recon chain for web applications, intelligently interpreting collected data, and optimizing …☆14Jul 3, 2024Updated 2 years ago
- My portfolio showcases impressive web projects with attractive designs, versatile functionalities, and optimized performance, highlightin…☆11Jun 9, 2023Updated 3 years ago
- Similar to fail2ban but optimized for performance and simplicity - programmed in Rust.☆18Aug 31, 2022Updated 4 years ago
- Small, performance optimized module for parallax image backgrounds 🖼☆10Feb 19, 2017Updated 9 years ago
- optimize TCP settings and download speeds of applications on Windows systems for improved network performance☆12Sep 16, 2026Updated last month
- Materials for a workshop on JVM performance optimization☆15Jan 27, 2024Updated 2 years ago
- Managed Database hosting by DigitalOcean • AdPostgreSQL, MySQL, MongoDB, Kafka, Valkey, and OpenSearch available. Automatically scale up storage and focus on building your apps.
- Optimize the performance of important tasks by delaying background-tasks☆22Mar 13, 2026Updated 7 months ago
- machine learning model performance metrics & charts with confidence intervals, optimized with numba to be fast☆16Dec 15, 2021Updated 4 years ago
- This project involves using Simulink to create a comprehensive battery model that incorporates both charging and discharging resistances.…☆11Apr 30, 2023Updated 3 years ago
- This project is a real-time Wav2Lip implementation that I am actively optimizing to enhance the precision and performance of audio-to-lip…☆11Dec 6, 2023Updated 2 years ago
- Easily optimize generic performance metrics in differentiable learning.☆17Jun 6, 2020Updated 6 years ago
- 10K+ req/s batch API client for LLM endpoints — Rust, async, load-balanced☆19Feb 21, 2026Updated 7 months ago
- Library with JIT (Just-in-time) compilation support to optimize performance of small and medium matrix multiplication☆14Apr 27, 2021Updated 5 years ago