Re: doubt on order of table scan

On 2005-10-15, News <news_connection_at_yahoo.fr> wrote:
> I don't know what matters but if I were who implement it I would sacn in the
> order of the indexed column if an index is used or in the order of page
> chains if it's scan without an index.

What good is the index for if the entire table must be scanned anyway?

Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/