Databases Reference
In-Depth Information
<
StmtSimple
StatementOptmLevel
=
"
TRIVIAL
"
StatementSubTreeCost
=
"
0.471671
"
StatementText
=
"
SELECT * FROM dbo.DatabaseLog
;
"
StatementType
=
"
SELECT
"
>
Listing 5-33.
Figure 5-9:
Trivial plan properties.
As I mentioned at the start of this chapter, additional information regarding the
optimization process can be shown using the
sys.dm_exec_query_optimizer_info
DMV, which will produce an output similar to Table 5-1 for this query.
Counter
Occurrence
Value
elapsed time
1
0
final cost
1
0.471671267
maximum DOP
1
0