Partitioning or indexing for millions of records
Hii all,
I have a table containing 20+ millions(will go to 60+ within month) of records. Now I have to fetch records very fast.
I am using MyISAM engine and i don't want to create problem during insertion(heard indexing can hurt insertion) of records. So please tell me which is better indexing or partitioning.
What other factors(cache or buffering) i should use. Please let me know with example if possible.
Thank you.
Edited 2 time(s). Last edit at 11/27/2013 12:58AM by Aamir Sohail.
Subject
Views
Written By
Posted
Partitioning or indexing for millions of records
3121
November 26, 2013 05:44AM
2321
November 27, 2013 12:39PM
1862
November 28, 2013 12:40AM
1945
November 28, 2013 09:07PM
1842
November 29, 2013 04:11AM
1793
November 30, 2013 01:30PM
1608
December 31, 2013 11:34AM
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.