Some issues in query plan operator

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Some issues in query plan operator

Author

Topic

HHR_mAY
Starting Member

2 Posts

Posted - 2010-01-11 : 06:28:32

Hi there,
I'm researching the sql server query plan issues,but now get into trouble.As you know,the logical&physical operator "Assert" exists in sql server query plan usual with an argument,such as
"Assert(WHERE : (If NOT(([Expr1006] IS NULL)) then 0 else NULL))".
But What's the "Expr1006" in the argument represents for? Where exists the definition for it?

Thanks
May

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-11 : 10:43:39

doesnt plan shows definition for expn1006?

HHR_mAY
Starting Member

2 Posts

Posted - 2010-01-11 : 20:12:28

quote:
Originally posted by visakh16

doesnt plan shows definition for expn1006?

Thanks for your reply.And My test environment is sql server 2000 and Northwind.Products Table. The sql statement and estimated query plan is shown below :

StmtText
delete from Products where ProductID = 1
|--Assert(WHERE: (If NOT(([Expr1006] IS NULL)) then 0 else NULL))
|--Nested Loops(Left Semi Join, OUTER REFERENCES: ([Products].[ProductID]), DEFINE: ([Expr1006] = [PROBE VALUE]))
|--Clustered Index Delete(OBJECT: ([Northwind].[dbo].[Products].[PK_Products]), WHERE: ([Products].[ProductID]=Convert([@1])))
|--Index Seek(OBJECT: ([Northwind].[dbo].[Order Details].[ProductsOrder_Details]), SEEK: ([Order Details].[ProductID]=[Products].[ProductID]) ORDERED FORWARD)

Thanks for your kindness
May

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources