ProviderData table and indexes - uniqueness question

Patrick_McManus

For the ProviderData table, the index ProviderData_IDX1 consists of ProviderType + ProviderID, but is NOT UNIQUE. Given that ProviderID is the unique primary key, and ProviderID and ProviderType are both non-nullable, how is it possible that ProviderType + ProviderID is not unique?

Appu Nair

If you have a copy of the NDA'd schema probably I would say consult that. I only know from experience that ProviderData <->DversData<>Dtree(Core) has a special meaning. If you add a File with a Version one record for that table is added with a providerID if you copy that File then another record will be added but with the same providerid .I remember seeing RefCnt as increasing in older versions but now it looks like that logic is changed.Think of this as Livelink's unique way of preventing same document bloat or a "single instancing".Perhaps could that be one of the reasons why those things are not the way you think?

as a simple test I made a copy of an object in my Cs16.2.8 livelink this 63536594 was the first DocId, 73878011 was the copy I made.

select dv.VersionID,dv.DocID,dv.Version, pd.* from DVersData dv , ProviderData pd
where dv.DocID in (63536594,73878011) and dv.ProviderId = pd.providerID;