Re: partitioning of a table

[Harold Content]

here is a simple example of a explain select

1 SIMPLE tblvbu ALL PRIMARY 13 Using temporary; Using filesort
1 SIMPLE tblvlocatie ref PRIMARY,key bu key bu 5 vm06inkdb1.tblvbu.vbuid 10 Using where; Using index
1 SIMPLE tblghdeb ref PRIMARY,Key locatie Key locatie 5 vm06inkdb1.tblvlocatie.vlid 1 Using where; Using index
1 SIMPLE tbldebart ref debkey,artkey debkey 5 vm06inkdb1.tblghdeb.debid 1829 Using where
1 SIMPLE tblart eq_ref PRIMARY PRIMARY 4 vm06inkdb1.tbldebart.AID 1