It all depends on the frequency of your scheduler..
If it wakes up every 10 seconds the blocks are already in memory so updating
the bitmap will not involve that much overhead.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
I usually use a switch in the scheduled job tables to indicate active
status.
After the job run jus NULL or put another value in it.
If you put bitmap index on this the search will be a snap.
There is no reason to hold this pointer in the jobs table.
Yechiel Adar
Mehish
- Original Message
My personal preference is with solution 2 - moving the current information to JOB. The
scheduler can quietly insert into JOB_HISTORY when it is done with a job, and update
the current line (do it through triggers if you like). Solution 3 violates the beloved
KISS principle ...
Moreover, when
Jacques,
Why make it sooo complicated? I like the third table - Job_History that
shows what job ran and when. Much clearer now, and in a year from now when
you (or someone else) goes and reviews what you did.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent:
Jacques,
What you are doing is not exactly data modeling: you are designing a database.
When data modeling, the database to be used is irrelevant. There are no columns
or primary keys, but there are attributes, and one or more unique identifiers.
From a DM perspective, I would be first
-Original Message-
Mercadante, Thomas F
Why make it sooo complicated? I like the third table -
Job_History that
shows what job ran and when. Much clearer now, and in a year
from now when
you (or someone else) goes and reviews what you did.
Because I can? Because when I make
-Original Message-
[EMAIL PROTECTED]
What you are doing is not exactly data modeling: you are designing a database.
I stand corrected. I am actually looking at a denormalized set of tables we have here
(there's a table with 52 columns: OBSERVATION1, OBSERVATION2, ... OBSERVATION52)
Merci beaucoup Monsieur. I agree with your point in the second paragraph.
-Original Message-
Stephane Faroult
My personal preference is with solution 2 - moving the
current information to JOB. The scheduler can quietly insert
into JOB_HISTORY when it is done with a job, and
-Original Message-
Yechiel Adar
I usually use a switch in the scheduled job tables to indicate active
status.
After the job run jus NULL or put another value in it.
If you put bitmap index on this the search will be a snap.
Except would you put a bitmap index on a column in a