Design Strategy

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "AM" <anonymous@xxxxxxxxxxxxxxxxx>
Date: Sun, 12 Jun 2005 17:22:36 +0530

Hi, all

My Fact table in from view and the view has a base table which has around 20
million rows. The base table joins to other tables and finally the views has
arround 6000 million rows.

So the question is What aggregation should I use and What care should I take
to get best optimal results.

--
Thanks

.

Follow-Ups:
- Re: Design Strategy
  - From: Myles.Matheson@xxxxxxxxx

Prev by Date: MOLAP partition size limit
Next by Date: Re: Design Strategy
Previous by thread: MOLAP partition size limit
Next by thread: Re: Design Strategy
Index(es):
- Date
- Thread

Relevant Pages

Re: Linked list question
... if (prev == NULL) ... Take care that you don't leak anything here. ...
(comp.programming)
Re: 102" whip
... >makes a Rat Shack whip such a bad design? ... I don't care what makes it bad. ... Do the test then you can hypothesize ... Prev by Date: ...
(rec.radio.cb)
Re: Cyclist killers in local paper.
... So that contradicts your first statement. ... Either applies and the word is valid, or your assertion that, "It ... Care to try again, this time using a consistent form logic throughout ... Prev by Date: ...
(uk.rec.cycling)
Re: Script to strip lines from files
... And that's all I care about. ... Thanks alot Etienne, and you ... Prev by Date: ...
(comp.unix.shell)
Re: Dynamic Comma delimited output
... >> If you don't care about the order in which the string aggregation ... >>but if you do care, does a SQL Server 2005 UDA help? ... >you can't go back and ask it to intervene in the UDA in any logical way I ... select CustomerID, MyAgg ...
(microsoft.public.sqlserver.programming)