View Single Post

   
  #6 (permalink)  
Old 02-28-2008, 10:21 AM
Captain Paralytic
 
Posts: n/a
Default Re: How can I use indexes to optimize my message board?

On 2 Aug, 04:04, Jason <jwcarl...@gmail.com> wrote:
> > an index makes searches a lot faster. if a record is in the bottom of your table,
> > an indexed search will find the record by reading one row whereas an unindexed
> > search will have to scan the whole table to find the record.

>
> Well, I thought I understood...
>
> Here's why I think I'm getting lost. Is the index something that I can
> PHYSICALLY use, or is it automatically used when I access a table?

Did you read the Manual starting at the link that I posted.

Reply With Quote