Subject RE: [ib-support] Table size and indexing
Author Fabricio Araujo
On Mon, 18 Jun 2001 20:16:25 +1000, Helen Borrie wrote:

>>
>>CREATE TABLE "RESPONSES"
>>(
>> "NUM" "POSITIVEBIGINT" NOT NULL,
>> "CAMPNUM" "POSITIVEBIGINT" NOT NULL,
>> "REGNUM" "POSITIVESMALLINT",
>> "CONTMODENUM" "POSITIVEBIGINT" NOT NULL,
>> "ADNUM" "POSITIVEBIGINT",
>>CONSTRAINT "RESP_PK" PRIMARY KEY ("NUM")
>>);
>>
>>CAMPNUM refers to the advertising campaign that generated the response.
>>CAMPNUM is likely to be in the hundreds (or very low thousands).
>
>Primary table in the structure?

You can do that. Just make the scripting app do this way. IB will accept
( and many others db also.. ) .



[]s Fabricio
Systems Developer