[Info-Ingres] Automatic partitioninng and unique keyed tables

martin.bowes at ctsu.ox.ac.uk martin.bowes at ctsu.ox.ac.uk
Mon Apr 16 08:54:02 CDT 2007


Hi Everyone,

I'm running Ingres2006 +p12125 on a64.lnx

Why is it that I cannot put an automatic partition on a  unique keyed 
table?

As I understand it, the automatic partition is just there to scatter the 
data randomly amongst the partitions. So to retrieve data it must go and 
look in each partition. Surely uniqueness would actually help not hinder 
that task?

Martin Bowes
--
Random Farscape Quote #3:
John - If this is part of some sick experiment, I'm going to bill them for
       the therapy.





More information about the Info-Ingres mailing list