Annotated schema with views?

From: "Joe" <morbidcamel@xxxxxxx>
Date: Wed, 22 Jun 2005 17:22:49 +0200

My database I am working with is very normalized so I ended up creating
views for certain tables which I then use in my XSD schema to select XML
from the DB.

The problem is the generated query does unecessary existence checks because
it doesn't read the underlying table column schema info.. the underlying
column is definately marked "NOT NULL".
....
(((((_Q6.A32 IS NOT NULL AND (_Q6.A32 =
N'11111145-110b-11c4-d8b3-c8c5154c131e') OR _Q6.A32 IS NOT NULL AND (_Q6.A32
= N'11111145-110b-11c4-d8b3-c8c5154c131d')) OR _Q6.A32 IS NOT NULL
....

How do I get rid of this unecessary checks. Surely it slows down performance
of the query.

.

Follow-Ups:
- Re: Annotated schema with views?
  - From: Michael Rys [MSFT]

Prev by Date: SP input XML and Return XML
Next by Date: Re: CDATA & FOR XML PATH
Previous by thread: SP input XML and Return XML
Next by thread: Re: Annotated schema with views?
Index(es):
- Date
- Thread