Member Avatar for Teddy112

Can anyone give a clear,short and simple explanation about database indexes?

  • 4 Contributors
  • 5 Replies
  • 159 Views
  • 4 Months Discussion Span
  • Latest Post Latest Post by Teddy112
Member Avatar for diafol

Do you have a particular RDBMS in mind?

Member Avatar for Teddy112

@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.

Member Avatar for Reverend Jim

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.

Member Avatar for Teddy112

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.