All Forums Database
drmkd17 54 posts Joined 10/12
04 May 2016
How to access a huge table.

Hi All,
 
I have a huge tbale having 323,456,1898 records. I need to join this table to other tables and also I have some views created on this table. But the Select to this table is really slow. 
I  understand i have to define a proper PI have stats collected but they are all in place. Suppose i want to select 20 columns from this table through a view it takes a long time and also to joint the tables. 
Can anybody provide any suggestions that would expeditre the select operation.
Thanks in advance. 
drmkd17

yuvaevergreen 93 posts Joined 07/09
06 May 2016

Try to partition the data based on the needs. A proper partition will speed up the operation.

You must sign in to leave a comment.