What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » SQL // Database questions

SQL // Database questions
Author: Message:
Wabz
Elite Member
*****

Avatar
Its Groovy Baby!

Posts: 3459
Reputation: 29
39 / Male / Flag
Joined: Jan 2003
O.P. SQL // Database questions
At the moment I'm doing databases and SQL  I understand most of what can and can't be done. But one thing really confuses me

How to use indexing.

I understandish how it works by creating unique records with more than just a primary key.

Like you can't use a compisite key to have the same person on the same date going to the same event  (if that makes sense)  as that person could aslo uniquely be sent to a different event on the same day.

But I just can't work out how indexing helps the situation.
Mess.be Forum Moderator
Messenger Plus ex-IRC Network Admin
Gimme a Rep!
12-09-2005 02:09 PM
Profile E-Mail PM Web Find Quote Report
RaceProUK
Elite Member
*****

Avatar

Posts: 6073
Reputation: 57
39 / Male / Flag
Joined: Oct 2003
RE: SQL // Database questions
Indexing accelerates sorts and searches on indexed columns. There's a small space penalty, as the index does need to be stored, but the speed gains far outweigh the space usage.
It's especially good when joining two tables, as the index makes it trivial to find the right tuple in the entity with the primary key, and join it to the tuple in the entity with the foreign key.
[Image: spartaafk.png]
12-10-2005 12:34 AM
Profile PM Web Find Quote Report
« Next Oldest Return to Top Next Newest »


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On