Re: Export times: affected by size of table or amount of data?

Andy Hardy <aph_at_ahardy.demon.co.uk> wrote:

>Hi,
>
>If I declare a 100Mb table with no data, will it export in less time
>than the same table full of data?
>
>I thought that export times were only dependent on the quantity of data
>stored, but my customer is telling me otherwise...
>
>Andy

Unless I am misreading my logs, the time required for export is dependent on the number of rows ( amount of data ) exported plus the various grants, indexes and constraints ( if any ) on that table....

So your empty table, regardless of size, should be much faster than one of the same # of MBs ( allocated ) with, say, 250000 rows of actual data...

. Received on Tue Jun 15 1999 - 09:48:32 CDT