Search
InstantDoc ID
GO

Browse By: Author | Issue

July 05, 2000 02:55 PM

Querying Distributed Partitioned Views

Rating: (0)
Itzik Ben-Gan, Kalen Delaney
SQL Server Magazine
InstantDoc ID #9097
Learn how SQL Server distributes queries across nodes
Editor's Note: This is the second article in a three-part series about distributed partitioned views in SQL Server 2000.

Distributed partitioned views are the core component of Microsoft's scale-out strategy. (For more information, see "Scalability Wars," page 7.) In "Distributed Partitioned Views," August 2000, we introduced SQL Server 2000's distributed partitioned view technology and demonstrate...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Hi
I have a question regarding quering partitioned views in Sqlserver2000. If I query a partitioned view, but don't know the values in the where clause, i.e. select * from viewA where intVal in(select intVal from tbl1). Will this result in an optimized query that searches only the relevant tables?


Pederb11/26/2004 7:35:14 AM

I have SQL2K enterprise on W2K advance.
I have tested a partitioned view. Only when the check constraints are added to the member tables during tables are created, this view works. But for the tables I added check constraints after the creation, the partitioned views don't work. (it is not SQL7)
Another thing is when I don't have top in select SQL server access all member tables when only one member table is needed.
Is it a bug or any configuration to be changed?

Yumiko Takedomi 3/12/2004 2:45:05 AM

You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.