Skip to Content
0
Former Member
Jul 13, 2015 at 05:04 PM

How to see partitions with partial indexes

13 Views

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.

This says

Partial Index - ASE 15.7 SP130 - SAP ASE - SCN Wiki

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,

syspartitions sp1,

syspartitions sp2

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.