algorithm DB problem

From: Eitan M <no_spam_please_at_nospam_please.com>
Date: Sun, 4 Jun 2006 17:31:44 +0200
Message-ID: <e5uqq0$g32$1@news2.netvision.net.il>

Hello,

For : Oracle 9i, VB. 6.

I have got a problem (related to DB),

there are 1000 columns, for each of 100 tables.

The status is exists or not exists (for each column - the existance rule is : if some none-null field exists in db).
(each of the table may have many rows).

Full table scan is must (no keys of the most of the columns) at least once.

I want a solution for a minimum search (minimum full table scans) that I will know if any of the column
exists or not.

(I have thought of something like :

search the first 1 column, then get answer for two columns, then get answer for 4, 8, 16, 32 etc...

, but I cannot see how can I solve the problem).

Need pseudo-code sample, please (preffered : VB. 6.0).

Thanks :) Received on Sun Jun 04 2006 - 10:31:44 CDT