HELP! need sparse index for archive engine tables!!!
Hi
You wrote
>>You have partitioned index support in 5.1, but that is it for the moment. The >>engine was designed for large summaries.
Q0:- Plz let me know how to use partitioned index / sparse index in Archive Engine. Where can i find documentation & examples.
Archive engine table uses very small disk space & provides better insertion performance (100,000 inserts/sec) than MyISAM. BUT very slow in retrieval!!!!
########
PROBLEM
########
Q1:- My Archive engine table has 300 partitions each having 500Million records. How to create SPARCE INDEX / PARTITIONED INDEX to INCREASE retrieval performance???
Q2:- IF ARCHIVE IS NOT GOING TO HELP, WHAT SHOULD I DO???
Q3:- SHOULD I MOVE TO MS SQL SERVER or ORACLE?
Thank you,
IR.
Subject
Views
Written By
Posted
HELP! need sparse index for archive engine tables!!!
11694
February 15, 2007 03:48AM
5932
February 16, 2007 06:52AM
6095
February 18, 2007 03:51AM
15669
February 19, 2007 05:56AM
6054
February 27, 2007 06:51PM
6171
March 04, 2007 01:29AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.