Re: composite keys indexing

2003-04-01 Thread Michael Brunson
On Tue, 1 Apr 2003 20:30:32 -0800 (PST), Jinesh Varia used a few recycled electrons to form: | Hello group, | | I have a simple composite key | create table a_b (aID int NOT NULL, bID int NOT NULL, primary key | (aID,bID)); | | Where aID is primary key in the table a and bID is the primary key in

composite keys indexing

2003-04-01 Thread Jinesh Varia
Hello group, I have a simple composite key create table a_b (aID int NOT NULL, bID int NOT NULL, primary key (aID,bID)); Where aID is primary key in the table a and bID is the primary key in table b, While my primary keys are automatically indexed, I am having problems when I use the bID. I re