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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.