Add index on _UserTableStat and _IndexTableStat

  • Thread starter Thread starter James Palmer
  • Start date Start date
Status
Not open for further replies.
J

James Palmer

Guest
If I want to find out Index and Table usage stats for a particular user I use the code below. It works fine but it's ridiculously slow, as is the one on _IndexTableStat that's similar. Please could an index for _UserTableStat-Conn and _UserIndexStat-Conn be added? FOR EACH _UserTableStat WHERE _UserTableStat._UserTableStat-Conn = iUsr NO-LOCK, FIRST _File FIELDS(_File-Name _Hidden) WHERE _File._File-number = _UserTableStat._UserTableStat-Num AND _File._Hidden = FALSE NO-LOCK: END.

Continue reading...
 
Status
Not open for further replies.
Back
Top