Re: Partition like option
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: smishra_97@xxxxxxxxx
- Date: Mon, 6 Nov 2006 19:15:51 -0500
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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
