Extent Size and Total amount of Extents 
Author Message
 Extent Size and Total amount of Extents
Hi ,

Is there any maximum size I can assign to the extent when creating a table?

Which is the maximum amount of total extents a table should have to optimize
its performance?

thx!

Emilio Gutter
Datatransfer S.A. - Argentina



Tue, 22 Jun 2004 05:21:37 GMT
 Extent Size and Total amount of Extents

Quote:

> Hi ,

> Is there any maximum size I can assign to the extent when creating a table?

The size of a chunk (2GB) practically the size or freespace in the chunks in the table's
dbspace

.

Quote:
> Which is the maximum amount of total extents a table should have to optimize
> its performance?

Fewer is batter.  >32 is usually bad

Art S. Kagel



Tue, 22 Jun 2004 07:07:56 GMT
 Extent Size and Total amount of Extents


Quote:
> > Is there any maximum size I can assign to the extent when creating a
table?
> Fewer is batter.

Sounds fishy advice to me.  Is this the right plaice for that sort of
opinion?  Some old snapper like Impy may pick you up on it.  You cod have
been more careful.


Tue, 22 Jun 2004 08:02:14 GMT
 Extent Size and Total amount of Extents
Quote:



>> > Is there any maximum size I can assign to the extent when creating a
>table?
>> Fewer is batter.

>Sounds fishy advice to me.  Is this the right plaice for that sort of
>opinion?  Some old snapper like Impy may pick you up on it.  You cod have
>been more careful.

Art has been truly caught on this one, hook line and sinker. Reel him in.

Do you fillet was really necessary to make your posting?

--
Space Corps Directive #997
Work done by an officer's doppleganger in a parallel
universe cannot be claimed as overtime.
    -- Red Dwarf



Tue, 22 Jun 2004 08:18:02 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Extents and next extent size

2. Initial extent size < first extent

3. Error: 1534 Severity: 20, State: 1 Extent:15480 not found in shared extent directory

4. Extent:15480 not found in shared extent directory

5. next extent-, exist extent-question

6. Extent/Next Extent

7. Extent/Next Extent

8. first extent and next extent

9. extent size and segment size

10. autoextend size vs. extent size in LMT

11. questions regarding extents' total


 
Powered by phpBB® Forum Software