Re: Cluster n-1 table like master table

Posted in 1998

david.ashby@workcover.nsw.gov.au — Fri, 01 May 98 09:58:16 +1000 — source: Informix-list mailing list archive (1991-1998)

Bernhard, You can't. The column must exist in the table that you are creating the index on. Regards David Ashby ______________________________ Reply Separator _________________________________ Subject: Cluster n-1 table like master table Author: <derix@forwiss.uni-passau.de (Bernhard Derix)> at WCA-INET Date: 30/4/98 2:30 PM If I have two tables with a n-1 relationship, it's possible to cluster them both according to the key of the master table. But if I don't cluster the key-attribut in the master table but another attribut, how can I cluster the referencing table along the same strategy ? (Because I don't have the cluster-attribut in the referencing table, but theoretically it's possible) -- Bernhard Derix email: derix@forwiss.uni-passau.de Homepage: http://www.forwiss.uni-passau.de/~derix/ Universitaet Passau, FORWISS, Zi. FMI 034, Innstr. 33, 94032 Passau Tel.: 0851/509-3144