How to access a huge table.

Database
Enthusiast

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

1 REPLY
Enthusiast

Re: How to access a huge table.

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