How fragmentated a table is? 
Author Message
 How fragmentated a table is?
Is there a way to check how fragmentated a table is?

Thanks in advance.

Ciao Alfredo.



Tue, 21 Jan 2003 03:00:00 GMT
 How fragmentated a table is?

Fields in sysindexes tells you the number of rows in each table and the
number of pages of each table.
You can use that to calc rows/page to determine the fragmentation.
Typically, the fragmentation is a lot more servere in index pages and data
pages. You may want to recreate the clustered index and take a row/page
number against all index pages and data pages and see the fragmentation grow
over time. In fact, you can even predict based on the (# of index pages)/(#
of datapages) ratio how much space you will save by defrag the table(as
indication of overall performance saving)

Luke

Quote:
> Is there a way to check how fragmentated a table is?

> Thanks in advance.

> Ciao Alfredo.



Thu, 23 Jan 2003 03:00:00 GMT
 How fragmentated a table is?
Hi

Quote:
> Fields in sysindexes tells you the number of rows in each table and
the
> number of pages of each table.
> You can use that to calc rows/page to determine the fragmentation.
> Typically, the fragmentation is a lot more servere in index pages and
data
> pages. You may want to recreate the clustered index and take a
row/page
> number against all index pages and data pages and see the
fragmentation grow
> over time. In fact, you can even predict based on the (# of index
pages)/(#
> of datapages) ratio how much space you will save by defrag the
table(as
> indication of overall performance saving)

in addition to that from version 11.9.2 onwards you can use the optdiag
tool.

rgds
--
Bernd Dulfer
Sybase Professional Services Germany

Sent via Deja.com http://www.deja.com/
Before you buy.



Fri, 24 Jan 2003 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. ROWIDs and Fragmentated Tables

2. I am getting this message when i am tring to export or import anything using

3. error ORA-01855: AM/A.M. or PM/P.M. required

4. Busy Day = Slowdown from 12 AM - 5 AM

5. Use of @am, Am I dumb?

6. Problem: I am trying to insert a query into a table

7. Can I add coulmn in my existing table which i am using for replication

8. Why am I doing a Table Scan?

9. Enterprize Manager locks up when i am trying to make changes to a table

10. HELP PLEASE - what table am i quering???

11. Patches (current CVS) for changes if index AM tables

12. which table am I using ?


 
Powered by phpBB® Forum Software