This question pertains to K2 2003 and also the BlackPearl product.
On Workspace (or search by API), search for folio or process data is done by wildcard, but for a large historical data this could be slow. Would SQL Server's built in full text index search be beneficial in this case or because of permissions involved it wouldn't be easily integrated?
For someone who has View rights to all processes with 1 million rows (which in term has probably a few million rows the way the data is stored in each field), that is a lot of records to scan through for %textstring% type of SQL operation.