dcsimg
LinkedIn
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Beginner
Aug 3, 2018

Optimize Your SQL Queries with Schema Names

SQL Server, by design, caches query plans for queries. For reuse of cache, the best practice would be to include the schema name in the query.

For example:

select * from dbo.accounts

This way, when this is cached, the cache can be reused by all users who execute this query.

Srinath M S
 
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date