7753485818
76%
BABEL_5_X_DEV: 77%

Ran 02 Feb 2024 09:22AM UTC

Jobs 1

Files 113

Run time 9s

Badge

Embed ▾

Committed 02 Feb 2024 08:44AM UTC coverage: 72.297% (-0.005%) from 72.302%

Build # 7753485818

Build Type

push

github

Committed by

web-flow

Commit Message

Performance improvements for SSMS query to enumerate tables (#2310)

Description

Earlier, we had improved the performance of queries involving joins between sys.tables, sys.all_columns and sys.types but we were still observing the bad performance of SSMS query to enumerate tables. This commit changes the definition of sys.types and sys.tables to use materialized CTE for sys.table_types_internal and rewrites sys.indexes system view.

Signed-off-by: Sumit Jaiswal sumiji@amazon.com
Issues Resolved

Task: BABEL-4625

Run Details

40730 of 56337 relevant lines covered (72.3%)

58564.09 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	7753485818.1	02 Feb 2024 09:22AM UTC	113	72.3	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 7753485818
76%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 7753485818

babelfish-for-postgresql / babelfish_extensions / 7753485818 76% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 7753485818

babelfish-for-postgresql / babelfish_extensions / 7753485818
76%
BABEL_5_X_DEV: 77%

README BADGES
x