Indexes

What are indexes, what are the different kinds, and how do they differ? Also, why and how do I use them. Most of the tutorials I have found for SQL have them, but don't really specify why they have them. Thanks.

Googling around and may find some answers like these:

How does a database index work?

http://forums.xisto.com/no_longer_exists/

Optimizing MySQL: Queries and Indexes

http://www.tutorialized.com/tutorial/Optimnd-Indexes/7139

http://forums.xisto.com/no_longer_exists/

How MySQL Uses Indexes

http://forums.xisto.com/no_longer_exists/

Those articles are not the best on earth but may give you some ideas of database indexes.

Thank you very much dungsport, they are very useful.

You're welcome (vote for me if you found my posts useful, )

A index page is just the default page most servers set for your website to not show the directory listing.As a security mesure it's nice to keep a index page within every directory of your website....But if you were talking about indexing...Well indexing is just used to help organise and make searching your computer faster. Major search engines have the best indexing technologie in the world...Which is why their results load so fast Example....GOOGLE--Hope that helped.

LOL, what a space waste!!!I dont wanna make this post but please read the original post before answer it.

Googling around and may find some answers like these:

How does a database index work?

http://forums.xisto.com/no_longer_exists/

 

Optimizing MySQL: Queries and Indexes

http://www.tutorialized.com/tutorial/Optimnd-Indexes/7139

http://forums.xisto.com/no_longer_exists/

 

How MySQL Uses Indexes

http://forums.xisto.com/no_longer_exists/

Those articles are not the best on earth but may give you some ideas of database indexes.

<{POST_SNAPBACK}>

Thanks

I always had some idea of what indexes where for. But that just clarifies the whole lot.