Skip to Content
0
Nov 08, 2018 at 06:38 AM

FBL1N - Display Line item

100 Views

Hi,

I have a problem with Line Item display in tx FBL1N.
On my DEV/TST system everything is ok and list is shown after ~20 sec.
On my PRD env. it takes more than 20 minutes.

I've checked in SM50 that problem is with RFBLG cluster table so we rebuild index with statistic update and it does not resolve my problem.

I checked also Est. I/O Cost for query plan and it's strange.
For DEV/TST - 0,003125
For PRD - 585,516


We migrate to SQL Server 2017 with datafile shrink.

Any ideas how to resolve this problem?