table scan?/

Why might the optimiser use a table scan even index is available?

Is it justcase where there is a query like select *
From DEPT;

where u need to retrieve all the rows from the table , so why bother to use the index, just scan the entire table? Please correct. Received on Sun Feb 17 2002 - 07:17:19 CST