RVO (3/12/2013)
Thanks for response guys !Some more clarification.
Looks like it's a problem with this particular table.
I did [SELECT TOP 30,000 * FROM ism_secmaster_price] which is located in the same database, it has 107,000 rows
and it takes 5 seconds to get the results. Although that table has only 9 columns, three of them are float.
[ism_secmaster_price] table has no PK, but has a clustered index.
[SELECT TOP 30,000 * FROM equity_ids]
takes 1 min 5 seconds.
So the tables are inside the same database and act very differently.
I suspect something is wrong with [equity_ids].
How do I check table defragmentation?
Here is a starter query
SELECT *
FROM sys.dm_db_index_physical_stats(NULL,NULL,NULL,NULL,'limited')
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events