PHP. ORM. NOSQL. NOSQL. MYSQL. JDBC. Databases. BUSINESS INTELLIGENCE. Index Optimization Tips. Alexander Chigrikchigrik@mssqlcity.com General concepts In this article, I want to show how you can improve the speed of your queries by choosing the proper indexes, what kinds of indexes MS SQL supports and what is the advantage and disadvantage of using indexes in particular situation.
There are clustered and nonclustered indexes. Kyle's Cousin » An Absolute Beginner’s Introduction to Database Indexes. Proper indexes on your tables are a crucial part of any Database design that requires advanced data retrieval.
For basic databases with only a few dozen records per table, indexes may not be absolutely necessary and even slow things down (if your RDBMS does not automatically ignores the index), but it’s still good practice to design your database with proper indexes from the start if you expect it to grow big. The minute your number of table records increases and you need to do more advanced select queries (eg. joining of multiple tables), efficiency and speed becomes important. Object-Relational Mapping Basics & Strategies.