Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index based database?
EscVector wrote:
> The tables are not narrow. > Example 27 col table has 26 single column indexes. > > Still normal? > > > Jim Smith wrote:
Please don't top post. Scroll to the bottom to reply.
Given that this is a warehouse it may be fine and it may be excessive.
Is is a "real" warehouse designed as one or just a copy of an OLTP schema?
Are they being used?
What index type?
What version of Oracle?
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Dec 14 2006 - 12:26:03 CST