Query Execution Plan - When is the Where clause executed?
Posted
by Alex
on Stack Overflow
See other posts from Stack Overflow
or by Alex
Published on 2010-05-24T18:48:21Z
Indexed on
2010/05/24
18:51 UTC
Read the original article
Hit count: 191
I have a query like this (created by LINQ):
SELECT [t0].[Id], [t0].[CreationDate], [t0].[CreatorId]
FROM [dbo].[DataFTS]('test', 100) AS [t0]
WHERE [t0].[CreatorId] = 1
ORDER BY [t0].[RANK]
DataFTS is a full-text search table valued function. The query execution plan looks like this:
SELECT (0%) - Sort (23%) - Nested Loops (Inner Join) (1%) - Sort (Top N Sort) (25%) - Stream Aggregate (0%) - Stream Aggregate (0%) - Compute Scalar (0%) - Table Valued Function (FullTextMatch) (13%)
|
|
- Clustered Index Seek (38%)
Does this mean that the WHERE clause ([CreatorId] = 1) is executed prior to the TVF ( full text search) or after the full text search?
Thank you.
© Stack Overflow or respective owner