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!!!
11459
February 15, 2007 03:48AM
5783
February 16, 2007 06:52AM
5952
February 18, 2007 03:51AM
15542
February 19, 2007 05:56AM
5914
February 27, 2007 06:51PM
6044
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.