CTFP suggestion issue

Open

#1,057 opened on Sep 13, 2022 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty: 4/5
Estimated time: 3-5 days
Newbie friendliness: 25/100

Issue type: Bug
Clarity: Needs clarification
Activity status: Stale
Tech stack: sql
Domain: databases

Research direction

Reproduce the SQL assessment on machines where the cost threshold is 50 or higher, then trace where the CTFP recommendation of 5 is generated. Compare that recommendation with the current configuration and Microsoft best-practice guidance; done means the reason for the suggested value is established and the issue has a clear resolution.

Written by the indexing model from the issue text.

Description

[When running SQL assessment in several machine which has Cost threshold set 50 and above it suggests to make it 5 ,but CTFP 5 is an old configuration ,any thought why this suggestion ?
As it suggests microsofts best practice ,why it is recommending CFTP to be configured as 5?

Dominant language: PowerShell
Stars: 11.2k
Forks: 9.1k
Avg merge: 2d 7h
Merged PRs (30d): 14

Contributor guide

No contributing guide indexed for this repository

First steps

Read the whole issue, then the project's contributing guide.
Comment on the issue to say you are picking it up — it saves two people doing the same work.
Fork the repository and make your change on a branch.
Open a pull request that references the issue number.

Similar issues

[BUG] CREATE property value with *, -, ^, % or unary minus is stored as its text ('2 * 3'); + and / are evaluated Open

bug

Difficulty 2/5 1-3 hours Newbie friendliness 75/100

orneryd/NornicDB#656 · Opened Sep 24, 2026
Statement leaks when a query fails to prepare, breaking `dbDisconnect()` Open

Difficulty 2/5 1-3 hours Newbie friendliness 75/100

r-dbi/adbi#73 · Opened Sep 24, 2026
[bug] GET /api/admin/audit-log forwards an unbounded `limit` to SQL LIMIT: ?limit=-1 dumps the whole audit table Open

Difficulty 2/5 1-3 hours Newbie friendliness 75/100

TencentCloud/Octop#1128 · 1 comment · Opened Sep 24, 2026
[bug][accuracy] Quebec basic personal amount is a year stale for every year (2024 holds the 2023 figure 17,183), which under-indexes the 2026+ Quebec IMR exemption Open

Difficulty 2/5 1-3 hours Newbie friendliness 75/100

elecnix/lifedraft#347 · Opened Sep 24, 2026
trace_query_origin makes DBConnector::isQueryType() classify every statement as non-mutable (replica routing sends writes to replicas, previewwrite executes writes) Open

Difficulty 2/5 1-3 hours Newbie friendliness 70/100

silverstripe/silverstripe-framework#12022 · 2 comments · Opened Sep 24, 2026

More Databases issues