LLAttrData Index

Barry_Monteret_(eu0016191user2_-_(deleted))

Hi, I have an MS Access application from which I want to display category and attribute information about some files in LiveLink.I have a series of SQL views that extract the relevant attribute information. Sadly these views take some time to run. Upon investigating this, I found that LLAttrData does not index the DefID field. It does, however, index AttrID.Does anyone understand why this would be so? What good is there in indexing AttrID without indexing DefID? Surely any views/queries looking for a particular attribute would also need to look for the particular category that the attribute belongs to.I have added the DefID into an index in a test server and my queries have reduced execution from 35 seconds to just 1 second.I have some (small) concern about the overhead I will introduce to general operations when I add this index into the live system.Does anyone have any experience with this (or similar) issue?Thanks,Barry.