Increasing number of open partitions in Sybase 15

BayernLB
BayernLB used Ask the Experts™
on
Hello,

I know how to increasing the number of open partitions but i need to know how to work this formula out:
number of open partitions=sum(number of local indexes * partitions in table) + (number of unpartitionedtables & indexes)
So that i can work out how much to increase my open partitions.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Joe WoodhousePrincipal Consultant
Most Valuable Expert 2012

Commented:
You could just run

   sp_countmetadata "open partitions"
   go

which will count them all for you. You can (and should) also run this for "open databases", "open objects" and "open indexes". Oversize the last two by 20% and 10% respectively as sp_countmetadata only counts permanent objects and you should allow some head room for temporary tables and indexes also.

You seem to have answered your own question though - or are you asking for how to figure out how many indexes you have, whether they're local or global, etc?

Author

Commented:
Thanks for this info.
I was trying to work out what commands i needed to run so that i come up with a figure for number of local indexes * partitions in table and number of unpartitionedtables & indexes.

Thanks
Principal Consultant
Most Valuable Expert 2012
Commented:
You could query the system tables for that. I don't have an ASE 15 handy but it would be pretty easy to figure out. syspartitions contains one row for each data and index partition; local indexes have partitionid = data_partitionid.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial