speeding up processing of whole table
537704Apr 9 2008 — edited Apr 9 2008I have to pull all records from a table and insert it somewhere else. Since it's the whole table that i need to process my SELECT statement doesn't have a WHERE Clause. Is there a special way to make the retrieval faster? Or ill have to stick with a full table scan and live with it?
Gregg