table scan?/
From: D'laila Pereira <dpereira_at_students.uiuc.edu>
Date: Sun, 17 Feb 2002 07:17:19 -0600
Message-ID: <Pine.GSO.4.31.0202170715260.19-100000_at_ux12.cso.uiuc.edu>
Date: Sun, 17 Feb 2002 07:17:19 -0600
Message-ID: <Pine.GSO.4.31.0202170715260.19-100000_at_ux12.cso.uiuc.edu>
Why might the optimiser use a table scan even index is available?
Is it justcase where there is a query like
select *
where u need to retrieve all the rows from the table , so why bother to
use the index, just scan the entire table?
From DEPT;