question about Index Pages
Hello all.
I am trying to calculate the space used for tables and indexes for make a
disk reorganization of my database.
The gry point is how to estimate the rigth size of an index.
I have near 2.5k indexes so making an oncheck -pt its a hard task... not
impossible !!!
Just wanting some clue about querying sysmater.
But also found in perfomance guide that there is a factor named propunique
that is relative to uniqueness of an index.
So the recursive question, is, (in fact i dont remember) how to look for
the uniqueness for a given key.
Thank you in advance and best regards.
Saludos.-
Leonardo Santagostini
<http://ar.linkedin.com/in/santagostini>;
--047d7b6225ae08bdc905121f3081
Are you trying to estimate space for new indexes or find out how much space
existing indexes are taking up?
If it is the latter, try this:
select dbsname, tabname, npused
from systabnames st, sysptnhdr sp
where st.partnum = sp.partnum
and ncols = 0
and nrows = 0
and nkeys = 1
;
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Wed, Mar 25, 2015 at 12:14 PM, Leonardo Santagostini <
lsantagostini@gmail.com> wrote:
> Hello all.
>
> I am trying to calculate the space used for tables and indexes for make a
> disk reorganization of my database.
>
> The gry point is how to estimate the rigth size of an index.
>
> I have near 2.5k indexes so making an oncheck -pt its a hard task... not
> impossible !!!
>
> Just wanting some clue about querying sysmater.
>
> But also found in perfomance guide that there is a factor named propunique
> that is relative to uniqueness of an index.
>
> So the recursive question, is, (in fact i dont remember) how to look for
> the uniqueness for a given key.
>
> Thank you in advance and best regards.
>
> Saludos.-
> Leonardo Santagostini
>
> <http://ar.linkedin.com/in/santagostini>;
>
> --047d7b6225ae08bdc905121f3081
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a1140f53891b8df05121f51ee