Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: 2 million row database from hell! help a newbie in over his head.

Re: 2 million row database from hell! help a newbie in over his head.

From: Mikito Harakiri <nospam_at_newsranger.com>
Date: Wed, 22 Aug 2001 16:12:12 GMT
Message-ID: <wRQg7.10654$2u.76220@www.newsranger.com> 






In article <lcHg7.182793$%a.7691942_at_news1.rdc1.sdca.home.com>, Carl says...



>If you have a very "popular" query, such as average rainfall for last year

>per region, create a table for this.  




If you have a very popular query, such as average rainfall for last year
per region, create a materialized view (snapshot) for this. More advanced (and
more relational) solution would be using index. I'm not sure if built-in indexes
for "group by" are readily available yet off the shelf, but with extending
indexing feature you can certainly program one.
Received on Wed Aug 22 2001 - 11:12:12 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US