Trouble maintaining large fact table

I have a fact table which holds historical records. This table is increasing
exponentially in size. To date there're already over 10 million records. I'm
having trouble maintain this table on updates and queries.

Can anyone recommend any way to deal with this?

Thanks.


.

Relevant Pages

  • Re: CMD stuff, what should I buy?
    ... > I can't recommend the TURBO232. ... I've never had any trouble with my Turbo-232. ... A SuperCPU is not necessary for the Turbo-232. ... Prev by Date: ...
    (comp.sys.cbm)
  • Re: CMD stuff, what should I buy?
    ... > I can't recommend the TURBO232. ... I've never had any trouble with my Turbo-232. ... A SuperCPU is not necessary for the Turbo-232. ... Prev by Date: ...
    (comp.sys.cbm)
  • Re: The true history of Islam
    ... > A critical analysis, written by an Historian using historical records. ... Murderers are not martyrs! ... Prev by Date: ...
    (alt.religion.islam)
  • Re: Work stands?
    ... I have the Park home version, and have used it extensively for 10+ years ... with absolutely NO trouble. ... > Can anyone recommend a good work stand? ... Prev by Date: ...
    (rec.bicycles.tech)
  • The true history of Islam
    ... written by an Historian using historical records. ... Lenghty, but revealing: ... Prev by Date: ...
    (alt.religion.islam)
Loading