Oracle7-style partitioning - UNION ALL view.
Btw, 20M rows is not that many. Also "new record are inserted every
minute" is not that much either. Perhaps, the answer is more efficient
indexing? (I would formulate it as more efficient SQL but since it's
3rd-party...)
On 11/3/06, Sanjay Mishra <smishra_97_at_yahoo.com> wrote:
> I had a big table around 20million record table where last few days of data
> is updated or new record are inserted every minute . Now in order to access
> the 20M record for update or Select is very expensive and performance is
> affected slowly. I cannot Archive the table as few times a day application
> need some old data and Application is third party. I cannot use Partition as
> I don't have Partitition license. Any other sugesstion is highly appreciated
--
Best regards,
Alex Gorbachev
The Pythian Group
Sr. Oracle DBA
http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 06 2006 - 18:15:51 CST
