SQLCheck automatically detects common SQL anti-patterns. Such anti-patterns often slow down queries. Addressing them will, therefore, help accelerate queries.
SQLCheck targets all major SQL dialects.
SQLCheck is free and open source software. It’s no longer maintained.
- Logical Database Design Anti-Patterns:
- Multi-Valued Attribute.
- Recursive Dependency.
- Primary Key Does Not Exist.
- Generic Primary Key.
- Foreign Key Does Not Exist.
- Entity-Attribute-Value Pattern.
- Metadata Tribbles.
- Physical Database Design Anti-Patterns:
- Imprecise Data Type.
- Values In Definition.
- Files Are Not SQL Data Types.
- Too Many Indexes.
- Index Attribute Order.
- Query Anti-Patterns:
- SELECT *.
- NULL Usage.
- NOT NULL Usage.
- String Concatenation.
- GROUP BY Usage.
- ORDER BY RAND Usage.
- Pattern Matching Usage.
- Spaghetti Query Alert.
- Reduce Number of JOINs.
- Eliminate Unnecessary DISTINCT Conditions.
- Implicit Column Usage.
- HAVING Clause Usage.
- Nested sub queries.
- OR Usage.
- UNION Usage.
- DISTINCT & JOIN Usage.
License: Apache License
|New to Linux? Read our Linux for Starters series. We start right at the basics and teach you everything you need to know to get started with Linux.|
|The largest compilation of the best free and open source software in the universe. Each article is supplied with a legendary ratings chart helping you make informed decisions.|
|Hundreds of in-depth reviews offering our unbiased and expert opinion on software. We offer helpful and impartial information.|
|Replace proprietary software with open source alternatives: Google, Microsoft, Apple, Adobe, IBM, Autodesk, Oracle, Atlassian, Corel, Cisco, Intuit, and SAS.|
|Getting Started with Docker helps you master Docker, a set of platform as a service products that delivers software in packages called containers.|
|Essential Linux system tools focuses on small, indispensable utilities, useful for system administrators as well as regular users.|
|Linux utilities to maximise your productivity. Small, indispensable tools, useful for anyone running a Linux machine.|
|Home computers became commonplace in the 1980s. Emulate home computers including the Commodore 64, Amiga, Atari ST, ZX81, Amstrad CPC, and ZX Spectrum.|
|Now and Then examines how promising open source software fared over the years. It can be a bumpy ride.|
|Linux at Home looks at a range of home activities where Linux can play its part, making the most of our time at home, keeping active and engaged.|
|Linux Candy reveals the lighter side of Linux. Have some fun and escape from the daily drudgery.|
|Best Free Android Apps. We showcase free Android apps that are definitely worth downloading. There's a strict eligibility criteria for inclusion in this series.|
|These best free books accelerate your learning of every programming language. Learn a new language today!|
|These free tutorials offer the perfect tonic to our free programming books series.|
|Stars and Stripes is an occasional series looking at the impact of Linux in the USA.|