Re: performace question...

Let me give you an oversimplified example:

All the rows of your table fit neatly into one database block. To access any row in that table, with a full table scan, requires reading one block.

Now let's throw an index on the column you are querying. Since the number of rows is pretty small in that table, the index will only contain one block as well. To access any row in that table, with an index lookup, requires reading two blocks (the index block and the table block).

Which do you suppose is quicker?

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"