Search Options
close
Search the following clips:
All Clips
news
science
politics
food
economy
art
technology
health
internet
religion
psychology
Sign Up
Install
Learn More
Login
SQL Server 2000, Indexed Views, Using the NOEXPAND Option
guercheLE
follow
0
3-28-2007 10:05 AM
347 views
tags:
sql
,
sql server
,
views
,
indexed views
,
noexpand
Add a Comment
Login
to Comment. Not a member yet?
Sign up
Today's Top Clips
Humans 'Have Six-hour Window' to Erase Memories of Fear
The Gorgeous Arctic Fox
Wacky Winter Weather
Global Warming Nonsense Coming to an End
Pet Tarantula makes eye contact with owner
This Back Flip Attempt Never Had A Chance [GIF]
It's always the woman holding you back
Certified Pet Therapy: Dogs visiting the sick and injured at hospitals +PICS
Cute yawning animals
No more for me !
visit the
Top Clips page
View the Top Clips from
March 28, 2007
Embed This Clip In Your Site...
<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/b08799f1-2e0a-429d-9d1d-b860bc005e6e/5D9E18AE-20EE-46BC-A593-52EB01F1A9BF/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://www.dell.com/content/topics/global.aspx/power/en/ps4q00_microsoft?c=us&cs=555&l=en&s=biz" href="http://www.dell.com/content/topics/global.aspx/power/en/ps4q00_microsoft?c=us&cs=555&l=en&s=biz" style="font-size: 11px;">www.dell.com</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.dell.com/content/topics/global.aspx/power/en/ps4q00_microsoft?c=us&cs=555&l=en&s=biz"><DIV class="para"><B>Using the NOEXPAND Option</B> </DIV><DIV class="para">The <I>NOEXPAND</I> option forces the query optimizer to treat the view like an ordinary table with a clustered index. In this case, the indexed view must be referenced directly in the <I>FROM</I> clause. For example:</DIV><P></P><P class="para"><I>SELECT Column1, Column2, ... FROM Table1, View1 WITH (NOEXPAND)WHERE ...</I></P></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.dell.com/content/topics/global.aspx/power/en/ps4q00_microsoft?c=us&cs=555&l=en&s=biz"><DIV class="para"><B>Using the EXPAND VIEWS Option</B> </DIV><DIV class="para">Alternatively, the user can explicitly exclude indexed views from consideration by using the <I>EXPAND VIEWS</I> option at the end of the query. For example:</DIV><P></P><P class="para"><I>SELECT Column1, Column2, ... FROM Table1, View1 WHERE ...OPTION (EXPAND VIEWS)</I> </P><P class="para">When this option is used, the query optimizer ignores all view indexes when estimating the low-cost method of covering the columns referenced in the query.</P></blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;"> </td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/5D9E18AE-20EE-46BC-A593-52EB01F1A9BF/blog/" title="blog or email this clip"><img src="http://content8.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>
New from the makers of Clipmarks:
Amplify.com - Don't just share the news...Amplify it!
Clipmarks
Home
New Clips
Top Clips
Dashboard
Popular Topics
News
Life
Science
Technology
Entertainment
Get Started
Sign Up
Install Clipping Tool
How Clipping Works
Clip-to-Blog™
ClipSearch
Tools and Resources
FAQ
ClipWeek
Top Clippers
Top Tags
Site Map
About Clipmarks
About Us
Contact
Copyright
Privacy
EULA
OK
