Greg Smith wrote:
On Sat, 21 Apr 2007, Nelson Kotowski wrote:
I identified that the cluster command over the lineitem table (cluster
idx_lineitem on lineitem) is the responsible. I got to this conclusion
because when i run it in the 1GB and 2GB database i am able to
complete this script in 10
On Sat, 21 Apr 2007, Nelson Kotowski wrote:
I identified that the cluster command over the lineitem table (cluster
idx_lineitem on lineitem) is the responsible. I got to this conclusion
because when i run it in the 1GB and 2GB database i am able to complete
this script in 10 and 30 minutes eac
>>> On Mon, Apr 23, 2007 at 10:52 AM, in message
<[EMAIL PROTECTED]>, "Nelson
Kotowski" <[EMAIL PROTECTED]> wrote:
>
> I don't get how creating only the indexes i cluster on would improve my
> cluster command perfomance. I believed that all other indexes wouldn't
> interfere because so far they'
Hi Heikki,
Thanks for answering! :)
I don't get how creating only the indexes i cluster on would improve my
cluster command perfomance. I believed that all other indexes wouldn't
interfere because so far they're created in a fashionable time and they
don't refer to any field/column in the orders
Nelson Kotowski wrote:
So far, i need to do it in three different scale factors (1, 2 and 5GB
databases).
My build process comprehends creating the tables without any foreign keys,
indexes, etc. - Running OK!
Then, i load the data from the flat files generated through DBGEN software
into these t
