Re: Sparse TEMP files

Karen <abvk_at_ureach.com> wrote in message news:<3D27E270.D86488D9_at_ureach.com>...
> b) the performance
> will be slower for the first queries that use the tablespace.

I'd like to know why the first use of a sparse tempfile would be slower than if the file were actually filled with data. If it *is* indeed true, it's probably not because the "holes" have to be written with real data; it may be because the inode pointers have to point somewhere instead of nowhere? Do you have a benchmark or a theoretical proof?

Yong Huang Received on Sun Jul 07 2002 - 22:52:20 CDT