Displaying index BTree 
Author Message
 Displaying index BTree

Apart from using "dbcc prtipge" and "dbcc page" (which is extremely
time consuming), does any one know af a tool to display the structure
(and contents) of an ASE 11.5 clustered index?

I am working on an application that makes extensive use of compound key,
unique clustered indexes and I am trying to ascertain the index
structure using different key orders for multiple variations in table
data.

The availability of a tool to display this graphically would save me a
lot of time.

Also if anyne knows of any detailed documentation of how Sybase handles
page splitting in the instance of compound key clustered indexes and
sequentially increasing key value insertions in particular (what happens
if the increasing key value is the the first key, a middle key or a last
key).

Martin Storer

Sent via Deja.com http://www.***.com/
Share what you know. Learn what you don't.



Mon, 19 Nov 2001 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. multi-column btree index for real values

2. Btree index extension question

3. Problem with btree index on 7.1.3

4. patch to allow btree indices on BYTEA

5. btree-indexing-engine

6. Database/Structures and Indexes - Btree?

7. pctfree setting for BTREE indexes

8. Problem with btree index?

9. btree indexing

10. Corrupt Btree Index

11. Btree Secondary Indexes

12. Btree Index Depth


 
Powered by phpBB® Forum Software