reference.RepoObjectSource_QueryPlan - U

type: U ( user table ), modify_date: 2022-09-05 18:17:56

RepoObject_guid: 3290291C-9D61-EB11-84DC-A81E8446D5B0

Description

references on column level

  • source: query plan analysis of the execution of a query like
    Vselect top (1) * into #foo from (SELECT * FROM sss.aaa)

First update query plan and write them into repo.RepoObject - U
then analyse the query plans and update results into

EXEC [repo].[usp_RepoObject__update_SysObject_query_plan]
EXEC [repo].[usp_RepoObjectSource_from_query_plan__update]

some query plans can’t be extracted, some can be extracted but not analyzed
in this case mark the RepoObject in repo.RepoObject - U

SET [has_execution_plan_issue] = 1

Examples

Entity Diagram

entity-reference.repoobjectsource_queryplan

Columns

Table 1. Columns of reference.RepoObjectSource_QueryPlan - U
PK Column Name Data Type NULL? ID

xml

NULL

nvarchar(4000)

NULL

uniqueidentifier

NOT NULL

xml

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

datetime

NULL

xml

NULL

nvarchar(128)

NULL

Definition
(CONVERT([bit],case when [source_column_name] like 'EXPR[0-9][0-9][0-9][0-9]' then (1) else (0) end))

bit

NULL

Definition
(CONVERT([bit],case when [target_column_name] like 'EXPR[0-9][0-9][0-9][0-9]' then (1) else (0) end))

bit

NULL

Foreign Key Diagram

entity_1_1_fk-reference.repoobjectsource_queryplan

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.repoobjectsource_queryplan

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.repoobjectsource_queryplan

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.repoobjectsource_queryplan

Column Reference Diagram

entity_1_1_colref-reference.repoobjectsource_queryplan

Indexes

idx_RepoObjectSource_QueryPlan__1

Column Details

_

const_info

const_info

xml

NULL

const_value

const_value

nvarchar(4000)

NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

source_column_info

source_column_info

xml

NULL

source_database_name

source_database_name

nvarchar(128)

NULL

source_schema_name

source_schema_name

nvarchar(128)

NULL

source_server_name

source_server_name

nvarchar(128)

NULL

source_table_name

source_table_name

nvarchar(128)

NULL

SysObject_query_executed_dt

SysObject_query_executed_dt

datetime

NULL

target_column_info

target_column_info

xml

NULL

is_source_column_name_expression

is_source_column_name_expression

Definition
(CONVERT([bit],case when [source_column_name] like 'EXPR[0-9][0-9][0-9][0-9]' then (1) else (0) end))

bit

NULL

Description

(CONVERT([bit],case when [source_column_name] like 'EXPR[0-9][0-9][0-9][0-9]' then (1) else (0) end))


is_target_column_name_expression

is_target_column_name_expression

Definition
(CONVERT([bit],case when [target_column_name] like 'EXPR[0-9][0-9][0-9][0-9]' then (1) else (0) end))

bit

NULL

Description

(CONVERT([bit],case when [target_column_name] like 'EXPR[0-9][0-9][0-9][0-9]' then (1) else (0) end))