7758160059
74%
BABEL_5_X_DEV: 77%

Ran 02 Feb 2024 04:23PM UTC

Jobs 1

Files 113

Run time 14s

Badge

Embed ▾

Committed 02 Feb 2024 03:36PM UTC coverage: 72.851% (-0.005%) from 72.856%

Build # 7758160059

Build Type

push

github

Committed by

web-flow

Commit Message

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

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

40986 of 56260 relevant lines covered (72.85%)

55698.87 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	7758160059.1	02 Feb 2024 04:23PM UTC	113	72.85	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 7758160059
74%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 7758160059

babelfish-for-postgresql / babelfish_extensions / 7758160059 74% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 7758160059

babelfish-for-postgresql / babelfish_extensions / 7758160059
74%
BABEL_5_X_DEV: 77%

README BADGES
x