Subject | IB´s Theory |
---|---|
Author | fesumus |
Post date | 2003-04-16T20:33:23Z |
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)
3. Data Page have only data for 1 table?
4. Index Page have only data for 1 index?
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?
6. When u chance a index field for same value, IB alter the index?
Sorry my poor english ;-)
Thx
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)
3. Data Page have only data for 1 table?
4. Index Page have only data for 1 index?
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?
6. When u chance a index field for same value, IB alter the index?
Sorry my poor english ;-)
Thx