Answer 1

They work pretty much like a index in a book. By looking at a book's index you can jump easily to where a chapter begins. Similarly, if you create an index on a table field, the SELECT statement with a WHERE on that field will return quickly the expected result. If there wasn't an index, the query would scan all of the table records one by one, thus giving a poor performance.