How to do the Partation of the Table
Posted on 2012-09-05
we are using oracle database 9i and database is in Unix server.
to acces oracle database we are Using SQLDEVELOPER:
In our database we have one Table which consits of 84million records:
To retervie the single query it is taking 20 min:
In that Table all columns are Indexed :
Table Consits of :ID,TIMESTAMP,NAME,VALUE,CLASS,CLASS_TYPE
HOW TO DO THE PARTION ON THESE
Thanks in Advance.