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.