On Fri, 25 Jun 1999, Jim Jennis wrote:
# Not only legacy apps, but data warehousing. Frequently in a production
# environment you use two sets of tables -- production and data
# warehousing...One (production) with "bare bones" indicies to maximize
# transaction performance, and one (a replicate in the data warehouse)
# that you "index the living daylights out of" so that the non db saavy
# managers who want to do ungodly joints and sorts on tables for
# organizational reporting get decent performance.
Creating lots of indices is far different from creating a single
index on a lot of fields. Data warehousing is the former. The problem is
that you can't create a single index with a large number of fields.
--
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
| Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________