How can you see partitions with partial indexes ?
I've created partial indexes but can't see how to check the partitions that have them.
sp_help just says "Partial Index" after it.
you can get it from status3 column using status3 & 256
I've used this query
select sp1.indid, sp1.partitionid, sp1.name, sp2.name
from sysindexes si,
where si.id = sp1.id
and si.indid = sp1.indid
and sp1.data_partitionid = sp2.partitionid
and si.status3 & 256 != 0
Note: don't use "si.status3 & 0x100 != 0" on little endian machines !!!! you have to use si.status3 & hextoint("0x100") != 0.