Subject RE: [ib-support] Re: IB´s Theory
Author Kotala Zdeněk
> -----Original Message-----
> From: fesumus [mailto:fesumus@...]
> Sent: Thursday, April 17, 2003 8:19 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Re: IB´s Theory
>
> > > Hi people ;-)
> > I have any questions for IB
> >
> > 1. I have the DB´s Statistics, what is "Fill Distribution" (for
> index
> > and tables)
> > 2. When IB need read a row (in page 1000), is it read all data page
> > (page 1000)? (1000 is a example)

yes

> > 3. Data Page have only data for 1 table?

yes

> > 4. Index Page have only data for 1 index?

yes

> > 5. Look this case... A page size is almost completed, and I need
> > insert a row... IB create a new data page or insert a row in 2 page
> > sizes?

I think yes

> > 6. When u chance a index field for same value, IB alter the index?
> >
> > 7. Exists Index Page version?


Look for IBsurgeon. It is good tool for discover gdb structure.
http://www.ibsurgeon.com/

Zdenek K.