What table tells you what documents a given customer might have on the research tab? Surely that information is kept in Tessitura somewhere...?
Is there a way to seperate this table into a different physical file from the rest of the database?
That table is 40gb (out of 48gb) in our current database file.
It would make LIVE to TEST refreshes much quicker.
Thanks
Damien