What are database Indexes?

Posted by kprojects on Jun 9, 2012 5:00 AM EDT
Linux.org; By Ron Steelman
Mail this story
Print this story

In this tutorial we are going to review indexes. I never cease to be amazed at how many people do not know what indexes are or how to use them. An index is simply a data structure that provides a fast access path to rows in a table based on the values in one or more columns (the index key). This allows for fast search techniques to be used to find the values ,rather than having to scan the entire table row by row, which results in much faster data retrieval. This can be a big performance booster in your environment, lowering the amount of time it takes to run a SELECT query and get data back.

Full Story

» Read more about: Groups: MySQL

« Return to the newswire homepage

This topic does not have any threads posted yet!

You cannot post until you login.