vizskywalker 0 Report post Posted March 26, 2005 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. Share this post Link to post Share on other sites
dungsport 0 Report post Posted March 27, 2005 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 Indexeshttp://www.tutorialized.com/tutorial/Optimnd-Indexes/7139 http://forums.xisto.com/no_longer_exists/ How MySQL Uses Indexeshttp://forums.xisto.com/no_longer_exists/ Those articles are not the best on earth but may give you some ideas of database indexes. Share this post Link to post Share on other sites
vizskywalker 0 Report post Posted March 27, 2005 Thank you very much dungsport, they are very useful. Share this post Link to post Share on other sites
dungsport 0 Report post Posted March 27, 2005 You're welcome (vote for me if you found my posts useful, ) Share this post Link to post Share on other sites
spacewaste1405241471 0 Report post Posted March 28, 2005 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. Share this post Link to post Share on other sites
dungsport 0 Report post Posted March 28, 2005 LOL, what a space waste!!!I dont wanna make this post but please read the original post before answer it. Share this post Link to post Share on other sites
Muddyboy 0 Report post Posted March 29, 2005 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 Indexeshttp://www.tutorialized.com/tutorial/Optimnd-Indexes/7139 http://forums.xisto.com/no_longer_exists/ How MySQL Uses Indexeshttp://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. Share this post Link to post Share on other sites