Re: How can I find the fillfactor?
Posted in 2000
a_blonde@mindless.com — — source: Informix-list mailing list archive (1991-1998)
---- you wrote:
>
> I know how to find the default fill factor for the indexes:
>
> select *
> from sysconfig
> where cf_name = "FILLFACTOR">
> But I don't know how can I get from within a 4gl program the fillfactor of a
> specific index if it's not the default. Where are stored all those new
> parameters of the "create index" instruction? (create index aaa on aaa (b)
> fillfactor 50)
That is because it is not stored Dude. Once it is set, you can grow to 100%, so the fillfactor is not required. You will just have to keep your original script.
AB
----------------------------------------------------------------
Get your free email from AltaVista at http://altavista.iname.com