It's a term used since the start of RDBMS.
There is no such thing as "Partial Table Scan",
but the thing stuck anyway. Usually abbreviated
to FTS. Assume: "read the entire table, first
inserted row to last inserted row". It can of course
have optimisations, such as parallel query.
--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
"Hari Om" <hari_om_at_hotmail.com> wrote in message news:d1d5ebe4.0309170939.1410f709_at_posting.google.com...
> what do you mean when one says "FULL Table Scans...."...? what are it
> other alternatives to full table scan.....?
>
> what does it exactly means....I saw that a lot in the postings
> relating to "Seperating Data and INDEX on different disk"
>
> THANKS!
Received on Thu Sep 18 2003 - 08:04:58 CDT
