Fast loading of a clustered table
From: Krzysztof (Chris) Koperski <"Krzysztof>
Date: Mon, 24 Jan 2000 11:55:29 -0800
Message-ID: <388CAE31.E817159B_at_statsci.com>
I am using a clustered table in my application. I load it using SQL*Loader.
The problem is speed. Even if a table is sorted it is very slow.
Date: Mon, 24 Jan 2000 11:55:29 -0800
Message-ID: <388CAE31.E817159B_at_statsci.com>
I am using a clustered table in my application. I load it using SQL*Loader.
The problem is speed. Even if a table is sorted it is very slow.
The direct path can not be used.
Is there any way to speed it up?
Thanks,
- Kris
Krzysztof Koperski, Ph.D., Research Scientist MathSoft Inc., Suite 500, 1700 Westlake Ave. N Seattle, WA 98109-3044, USA Tel 206.283.8802 x243; FAX 206.283.8691