Re: Performance while Building Indices -- how does it scale?

2002-09-23 Thread Joseph Bueno
Chris Stoughton wrote: > I have a table with a few million rows, wth 633 columns. I want to > create 10 inidices on this table, six single-column and four two-column > inidices. The database will be loaded once and remain static, and > queried many times. Please note that this is a "small" p

Performance while Building Indices -- how does it scale?

2002-09-22 Thread Chris Stoughton
I have a table with a few million rows, wth 633 columns. I want to create 10 inidices on this table, six single-column and four two-column inidices. The database will be loaded once and remain static, and queried many times. Please note that this is a "small" prototype for the actual databa