CODEWITHSUNDEEP
sql-serverperformanceview
Marek Kwiendacz
Marek Kwiendacz

Reputation: 9834

Does adding many views to DB affects performance?

I want to add many views to DB to simplify work with it. I want to use those views only in Server Management Studio for fast testing of DB, querying history, error logs etc.

I think, that count of standard views (not indexed) doesn't affect DB performance.
Am I right? Can I add for example 100 views with no decrease of DB performance?

Upvotes: 0

Views: 214

Answers (3)

Aliostad
Aliostad

Reputation: 81660

Adding more views, if in hundreds, will not affect the performance. At the end of the day, most of the schema catalog is in memory anyway and is loaded once.

Upvotes: 1

Widor
Widor

Reputation: 13275

The number of Views available on the DB won't affect performance - however, the way the Views are written and how they get used - will.

Upvotes: 2

Oded
Oded

Reputation: 499002

100 views are not many, and having many views shouldn't affect performance.

Upvotes: 1

Related Questions