1664971 - Title Search in infoview returns no results or timesout

After migrating large repository to XI3.1, the Title search in Infoview does not return any results and CMS trace logs show the query timeout.

2011/12/06 16:49:24.454| | | 1848|5892|CInfoStoreSubsystem::Query:[UID=32233446;USID=32235100] SELECT TOP 30 EVERY 15 SI_KIND,SI_NAME,SI_ID FROM CI_INFOOBJECTS WHERE ((CHILDREN("SI_NAME='Category-Document'","SI_ID=23 OR SI_ANCESTOR=23") OR SI_ANCESTOR=23) AND ((SI_KIND IN ('Pdf','Agnostic','CrystalReport','FullClient','FullClientAddin','FullClientTemplate','Flash','Folder','Hyperlink','Excel','Powerpoint','Word','MyInfoView','ObjectPackage','Program','Publication','Rtf','Shortcut','Txt','MDAnalysis','Webi','Xcelsius') AND SI_INSTANCE=0) OR (SI_KIND IN ('ObjectPackage','FavoritesFolder','PersonalCategory','Inbox','Category','Folder') AND SI_INSTANCE=0)) AND (SI_NAME LIKE '%countryselection%')) ORDER BY SI_KIND CUSTOM('Folder', 'FavoritesFolder', 'Category', 'PersonalCategory', 'Inbox', 'ObjectPackage'),SI_NAME ASC,SI_ID ASC : (proc=false,chk=true,srv=false)
....
9 minutes later :

2011/12/06 16:58:24.441| | | 1848|5892|DBQueue::Read
2011/12/06 16:58:24.457| | | 1848|5892|ThrowOnThreadTimeout currTime: 11/12/06 11:58:24.457   expireTimeout: 540000
2011/12/06 16:58:24.457| | | 1848|5892|THREAD TIMEOUT! throwing exception now
2011/12/06 16:58:24.473|E|X| 1848|5892|DBQueue::Read: 0.032

• Xi3.1 any version
• Oracle CMS DB
• Windows

title; search; infoview; results; no; timeout; category; folder , KBA , BI-BIP-DEP , Webapp Deployment, Networking, Vulnerabilities, Webservices , Problem