Check records count in a view (T_SQL and Enterprise manager)

[lyudmila]

How i can check records count in a view (T_SQL and Enterprise manager)

 

[JohnDTampaBay]

SELECT Count(*) FROM ViewName

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[lyudmila]

Takes only few seconds to create a view but it takes forever to read from view! Is it common problem or it's a problem on iur server, I did not use view before. Please respond, I need to figure it out! have no time!
Thank you!

 

[JohnDTampaBay]

Ah, I suspected the answer wasn't that easy. Can you provide the code for the view? How many tables are involved in the view? Are JOIN columns indexed?

A view is nothing more than a pre-compiled SELECT statement. I suggest taking the SELECT statement of the view and run it in Query Analyzer with Show Execution Plan turned on. When it finally finishes, review the execution plan. Look for table scans and clustered index scans. If you can create indexes to eliminate the scans, then you'll probably improve performance.

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.