Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export times: affected by size of table or amount of data?
In article <376666ca.1629533_at_news.dot.state.mn.us>, TurkBear <john.greco
@nospam.dot.state.mn.us> writes
>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...
>
>.
And that's what I believe! I'll send the customer a custard pie...
Andy
--
Andy Hardy. PGP key available on request