Symptoms
Inquiry:
Is it possible to add an index to K2ServerLog._procInst on field K2ServerLog._procInst.Folio? We are running some queries to get information from that table and adding that index should improve those queries.
Diagnoses
Direct manipulation of the K2 database is not supported
Resolution
Short answer is 'NO'. While this may be possible by changing the K2ServerLog._procInst table design in SSMS, direct manipulation of the K2 database is not supported as this will break your K2 Support Agreement.
Also keep in mind that K2 at any time with any new release can change database schema and/or structure.
Thanks,
Samson.