Skip to Content
0
Former Member
Jan 12, 2011 at 07:08 AM

B1 8.8 PL18 Query view IBT1 too slow

167 Views

My Company B1 system version 8.8 PL18,query:

select * from IBT1_LINK, recorded a total of 3347 seconds with a time 00:00:00,

the query:

select * from IBT1, spent 20 minutes the result has not come out.

I was in SQL Server 2005 database, the query manager to search.

Who can tell me how to optimize the query IBT1 speed, I use a lot of inquiries, reports the view IBT1