[mailto:IBezdziecka;cupe.ca]
Sent: Wednesday, October 16, 2002 5:14 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Can I index this query? slightly OT-just InterMedia Text
opt
Thank you.
You are lucky, I have an Intel system with 1 CPU and 1 36GB
drive. This box is running Oracle 8.1.7, IIS
You could always consider something like OracleText to
assist with these kind of searches, but thats a big
step..
hth
connor
--- Carle, William T (Bill), ALCAS [EMAIL PROTECTED]
wrote: Howdy,
I have a table that has almost 2 million rows
called eventqueueentry. The layout looks like
Hi,
Atleast you can do one thing if you are having Oracle Pratitioning then just
partition it on the QueueType field provided you are having almost same
number of 3 different values. Place all partition on differnet harddisks and
if possible put them on different controllers.
In that case your
McDonald [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 16, 2002 4:24 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Can I index this query?
You could always consider something like OracleText to
assist with these kind of searches, but thats a big
step..
hth
connor
-
From: Connor McDonald [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 16, 2002 4:24 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Can I index this query?
You could always consider something like OracleText to
assist with these kind of searches, but thats a big
step
System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: Inka Bezdziecka [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 16, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Can I index this query
-L
Subject: RE: Can I index this query? slightly OT-just InterMedia Text
option
Jesse,
since you o have such a good experience, could you please
comment on the following:
I have installed InterMedia Text (8.1.7 on Win2K sp.2) and
400MB has grown to 4.5 GB.
There are 4 required
If that content is statics, create a column that called TRACKINGEVENTID
stores 'TrackingEventId='. Is EVENTID the same as TRACKINGEVENTID?
Partition it by QUEUETYPE so that it only goes after one patition instead
the entire table if partition does not affect other SQLs.
Bing Wong
