SQL Query for Index bit-type?
Hi,
I'm looking for a way to identify the 32-bit indexes from SQL.
The purpose is to identify 'older' archives and update them to 64-bit indexes outside of the active user updgrade schedule.
I have the below to identify 'older' archives but can't seem to find an obvious index bit-type in any of the tables.
Any help greatly appreciated.
Thanks
SELECT A.ArchiveName "Archive Name", AP.ModifiedDate "Archive Last Modified", COUNT(s.ArchivePointIdentity) "Item Count" FROM EnterpriseVaultDirectory.dbo.Archive A, EnterpriseVaultDirectory.dbo.Root R, EVVSEVARCAPSTR01_1.dbo.ArchivePoint AP, EVVSEVARCAPSTR01_1.dbo.Saveset S WHERE A.RootIdentity = R.RootIdentity AND R.VaultEntryId = AP.ArchivePointId AND AP.ArchivePointIdentity = S.ArchivePointIdentity AND AP.ModifiedDate < '2014-01-01' GROUP BY A.ArchiveName, AP.ModifiedDate ORDER BY "Archive Name"
Hiya,
I used the below. I added "and AR.ArchiveName like 's%', to be able to get lesser results. You could remove that. query orders names per items to index.
USE EnterpriseVaultDirectory
Select AR.ArchiveName, IV.RootIdentity, IV.IndexedItems, IV.FolderName, IV.IndexVolumeType from IndexVolume IV
Join Archive AR on IV.RootIdentity = AR.RootIdentity
Where IV.IndexVolumeType = 0
and AR.ArchiveName like 'S%'
order by iv.IndexedItems