USA: 1800-939-5570
Australia: 02-9262-7770
UK: +44 (0)20 3151 3000
Introduction to Database Indexes
By Chris Smith
Well there you have it -- my introduction to database indexes. Hopefully you've learned something from this article and can apply what you've learned to your own databases.
Article Series
This article is part 3 of a 4 part series. Other articles in this series are shown below:
-
Introduction to Database Indexes
Related Articles
22 Responses to "Introduction to Database Indexes"
Fill in the form below to leave a comment and share your thoughts.|
said this on 17 Feb 2006 7:13:50 AM CST
I think you need to be a bit more "the reader knows absolutly nothing" when describing the table joins. You lost me for a bit there. Perhaps a better step by step hand holding example would be better.
[ Editors note: Sure thing. I'll see what I can come up with for next month! If you're desperate for information and can't wait - drop me a line - chris at interspire dot com and I'll explain it further ] |
Author/Admin)|
said this on 14 May 2006 3:55:02 PM CST
Good effort chris,
You 've described Indexes in a simple way. |
|
said this on 24 May 2006 1:32:17 PM CST
Good article.Do include some explanation on clustered and non clustered indexes.
|
|
said this on 13 Jul 2006 3:25:24 AM CST
Good article. Helped a lot in understading the basics of indexing. Thanks
|
|
said this on 11 Oct 2006 8:43:39 PM CST
Good article man. I really appretiate your effort.
|
|
said this on 14 Nov 2006 9:22:37 AM CST
Good article to understand indexes for a beginner.
|
|
said this on 27 Nov 2006 5:21:04 PM CST
Very well written and simply explained for those looking for a basic overview
|
|
said this on 14 Dec 2006 11:46:30 AM CST
Good article, felt like walking over the bridge on a gorge. Can u pl. explain drawbacks of using index also.
[ Chris' note - The main drawback is that every insert, update or delete has to change the index as well. If you have a lot of indexes, that adds a lot of overhead to the operation. ] |
|
said this on 19 Dec 2006 11:56:49 PM CST
Very easy to understand and gives examples with different
situations to demonstrate when and where we should use indexes and why. Thanks man! |
|
said this on 14 Mar 2007 2:57:13 AM CST
A quick a useful reminder to what idexes are all about, thanks.
|
|
said this on 26 Jun 2007 3:11:31 AM CST
Good Introduction to Indexes. It would also be valuable to have information on how do indexes work on OLAP side of a Data Warehouse.
|
|
said this on 10 Oct 2007 11:33:45 PM CST
This is a great article to learn indexing for beginners I really appreciate your efforts and good will in explaining them in words here.Thanks!
|
|
said this on 12 Oct 2007 8:23:17 AM CST
This was a great explanation of indexes for me - I am self-taught when it comes to databases so the language in this tutorial was very easy for me to understand. Also, you used great examples to help explain your information. THANKS!
|
|
said this on 28 Oct 2007 4:58:02 AM CST
The explaination on the usage of indexing is very helpful
|
|
said this on 29 Oct 2007 1:56:28 PM CST
Thank you very much, a really informative tutorial...for me it was a 100% match to what I was looking for. Thanks...
|
|
said this on 11 Jan 2008 7:17:56 AM CST
Great article on indexes even oracle has not provided that much knowledge about indexes
|
|
said this on 11 Jan 2008 4:25:41 PM CST
Good. Just the overview i needed.
|
|
said this on 17 Jan 2008 3:39:07 AM CST
Great article...this is very simple to understand whole disadvantages about index...
|
|
said this on 18 Jan 2008 2:26:17 AM CST
impossible....even wikipedi couldnt match your tutorial on this topic...thank uuuuuuuuuuuuuuu very much
|
|
said this on 12 Sep 2008 5:57:52 AM CST
thanks Chris, was an easy read for a database novice. I look forward to seeing the next chapter :-)
|
