Can anyone give a clear,short and simple explanation about database indexes?
Teddy112
0
Newbie Poster
Recommended Answers
Jump to PostYou mean like the first paragraph of https://en.wikipedia.org/wiki/Database_index ?
Jump to PostIt's like using an index at the back of a book to get the page (address) of a particular topic. Instead of scanning the book looking for the topic you just get the address from the index and go directly there. You can add an index for any field (or …
All 5 Replies
gusano79
247
Posting Shark
diafol
Do you have a particular RDBMS in mind?
Teddy112
0
Newbie Poster
@diafol thanks..yes taking RDBMS in mind Indexes how plays role in databases?
@gusano79 i m not asking about first paragrah of wiki that i already can see but i need a clear explanation that can help in understanding indexes well...i am bit of confused in keys and indexes.
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
It's like using an index at the back of a book to get the page (address) of a particular topic. Instead of scanning the book looking for the topic you just get the address from the index and go directly there. You can add an index for any field (or combination of fields) but with every index you add there is a penalty in that it requires extra space for the index and extra processing time to maintain the index.
Teddy112
0
Newbie Poster
Thanks for the clear explanation Jim.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.