Thanks, I appreciate the quick response!

Hi all,

Thanks for your valuable inputs, I was able to fix the performance of the select query using Vertical partitioning.

Thanks again!

@sean Lange.

I certainly have no intention to ignore anybody who is trying to help me. If thats the message being conveyed, my apologies.

So lets start from beginning...

Data is used by a some other application which i have no idea about.

I dont think it is one by one operation.

Will it help if I clustered index on the table by adding a identity column to it. As of now, its a heap because there is no index and we...

"To deal" means I am asking for suggestion about How to make it faster. It is the slow performing query now. Select * from Table.

My apologies, if i am not clear about this.

Yes, you are right, the problem now is the select * from Table query. This table has 85 columns and 3 million...

It is a nightly ETL job. Once the data is loaded in the staging table, the process picks it up and loads into other system.

@SSChampion - At this point, it is basically select * from table. This is table has 85 columns. Why i am saying this is because the query to load...

Hi there,

I got this working. Following is the method i used to make it work in case someone else is in same situation :

You need to add a function...

I am facing the same problem. Can you please share the issue and the solution.

Thanks

Nee