Newbie Question #2:
I read about indexes, but wonder what they are used for...? I understand how to make indexes in tables, but why even bother to create an index when you can live without them?
Does indexes optimize table search time or anything the like?