: (bcc: Rachel Carmichael) |
| Subject: Re: Do you ever have days where |
| you dont want to think ? |
>|
Larry Elkins wrote:
>
> The beach part sounds great, though I don't care to see
My favorite Shakespearean (sp?) play
and yes, I think we should move this to the OT list :)
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> "Sherman, Paul R." wrote:
> >
> > Sigh no more, ladies, sigh nor more;
> > Men were deceivers ever;
> > One foot in sea and one on shore,
> > T
"Sherman, Paul R." wrote:
>
> Sigh no more, ladies, sigh nor more;
> Men were deceivers ever;
> One foot in sea and one on shore,
> To one thing constant never;
> Then sigh not so,
> But let them go,
> And be you blithe and bonny;
> Converting all your sounds of woe
>
ROFL -- this whole thread has kept me cracking up all morning !!!
-- (Mrs.) JoJo :D
-Original Message-
Paul R.
Sent: Monday, May 20, 2002 11:35 AM
To: Multiple recipients of list ORACLE-L
Sigh no more, ladies, sigh nor more;
Men were deceivers ever;
One foot in sea and one on sho
ah but who says Henry Higgins was right?
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
> >
> > as one of the women in this profession, do I want to know who you
> consider
> > "honorary men"? :)
> >
> > What I do want to know is how you determine what the criteria
05/18/2002 |
> || 11:13 AM |
> || Please |
> || respond to |
> || ORACLE-L |
> || |
> |+--->
> >|
> | |
> |
t; > || |
> > |+--->
> > >--------------------|
> > ||
> > | To: [EMAIL PROTECTED] |
> > | cc: (bcc:
respond to |
|| ORACLE-L |
|| |
|+--->
>|
||
| To: [EMAIL PROTECTED] |
| cc: (bcc: Rachel Carmichael) |
|
| sfaroult@orio|
> > > || le.com |
> > > || |
> > > || 05/18/2002 |
> > > || 11:13 AM |
> > > || Please |
> > > || respond to |
> > > || ORACLE-L |
> > > |
|
|| ORACLE-L |
|| |
|+--->
>|
||
| To: [EMAIL PROTECTED] |
| cc: (bcc: Rachel Carmichael) |
| Subject: Re: Do you ever have days where |
| you dont want to think ? |
>--
05/18/2002 |
> || 11:13 AM |
> || Please |
> || respond to |
> || ORACLE-L |
> || |
> |+--->
> >|
> | |
>
|
> > || 05/18/2002 |
> > || 11:13 AM |
> > || Please |
> > || respond to |
> > || ORACLE-L |
> > || |
> > |+--->
> > >--------------------
To: [EMAIL PROTECTED] |
| cc: (bcc: Rachel Carmichael) |
| Subject: Re: Do you ever have days where |
| you dont want to think ? |
>|
Larry Elkins wrote:
>
> The beach
[EMAIL PROTECTED] |
| cc: (bcc: Rachel Carmichael) |
| Subject: Re: Do you ever have days where |
| you dont want to think ? |
>|
Larry Elkins wrote:
>
> The
[EMAIL PROTECTED] wrote:
>
> as one of the women in this profession, do I want to know who you consider
> "honorary men"? :)
>
> What I do want to know is how you determine what the criteria are for being an
> "honorary man".
>
> Inquiring minds want to know :)
>
> Rachel
>
Well, coming fro
| ORACLE-L |
|| |
|+--->
>|
||
| To: [EMAIL PROTECTED] |
| cc: (bcc: Rachel Carmichael) |
| Subject: Re: Do you ever have days where |
|
|
> | To: [EMAIL PROTECTED] |
> | cc: (bcc: Rachel Carmichael) |
> | Subject: Re: Do you ever have days where |
> | you dont want to think ? |
>
|
|| ORACLE-L |
|| |
|+--->
>|
||
| To: [EMAIL PROTECTED] |
| cc: (bcc: Rachel Carmichael) |
| Subject: Re: Do you ever have days where |
| you dont want to think ? |
>-
you ever have days where |
| you dont want to think ? |
>|
Larry Elkins wrote:
>
> The beach part sounds great, though I don't care to see naked men running
> around ;-)
That's the problem
| cc: (bcc: Rachel Carmichael) |
| Subject: Re: Do you ever have days where |
| you dont want to think ? |
>|
Larry Elkins wrote:
>
> The beach part sounds great, though
> -Original Message-
>
> In fact, I would be
> curious to compare the join on the inline-view with a MINUS to the hash
> anti-join. Assuming all correct indexes, it is comparing two index fast
> full scans plus sort plus index search to two table full scans (more or
> less).
There was a t
Larry Elkins wrote:
>
> The beach part sounds great, though I don't care to see naked men running
> around ;-)
That's the problem in this job. Too many men. And among women, too many
are like honorary men.
Still preaching the gospel, as you can see :-). In fact, I would be
curious to compare
Elkins
[EMAIL PROTECTED]
214.954.1781
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> [EMAIL PROTECTED]
> Sent: Friday, May 17, 2002 5:53 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Do you ever have days where you
Don't have time to help with the query but following this link may help
with the first part:
http://images.google.com/images?hl=en&lr=&q=naked+beach
(you military guys, one tract minds...lol)
Brian P. MacLean
Oracle DBA, OCP8i
Sorry I dont want to think!!
-Original Message-
Sent: Friday, May 17, 2002 5:23 PM
To: Multiple recipients of list ORACLE-L
I just just wanna go lie on a beach naked
on some remote island far far away and not
think of anything for a month.
Here is the issue.
I have a query that lo
Yeah, I have those days.
The beach sounds good; don't worry, I'll go find my own.
Wouldn't want to frighten the natives.
Try 'not exists', 'not in' forces a table scan.
Even better, use an explicit anti-join.
select a.f1, a.f2, a.f3, a.f4
from table1 a, table2 b
where a.f1 = b.n1(+)
and b.n1
Title: RE: Do you ever have days where you dont want to think ?
Mike,
WheretheheckisOLN-AFMC? Okie City?
Anyway, it seems to me that the non-unique index on a.f1 is a waste of space as a.f1 is the first field of the primary key index.
Have you tried a hint?
select /*+ index(table1
I'm not sure an index would ever be used with not in (in seems to be bad
enough). Not exists would probably be quicker though it'd probably be
reasonable still to do a full table scan of a.
Personally I prefer the likes of minus though it'd be a bit convoluted here
e.g.
select a.f1, a.f2, a.f3,
Try...
select a.f1, a.f2, a.f3, a.f4 from table1 a
where not exists
(select b.n1 from b where b.n1 = a.f1);
Let me know...
Chris
-Original Message-
Sent: Friday, May 17, 2002 5:23 PM
To: Multiple recipients of list ORACLE-L
I just just wanna go lie on a beach naked
on some remote isl
"Johnson, Michael" wrote:
>
> I just just wanna go lie on a beach naked
> on some remote island far far away and not
> think of anything for a month.
>
> Here is the issue.
>
> I have a query that looks like this ...
>
> select a.f1, a.f2, a.f3, a.f4 from table1 a
> where a.f1 not in
> ( s
-- "Kirsh, Gary" <[EMAIL PROTECTED]>
> It's not using the index because of the NOT IN - it doesn't help to search
> an index to see what's NOT in it. Did you try rewriting it to use a NOT
> EXISTS instead?
Which can quickly degenerate into a tablescan also... even
if the index exists if the e
It's not using the index because of the NOT IN - it doesn't help to search
an index to see what's NOT in it. Did you try rewriting it to use a NOT
EXISTS instead?
Gary
Gary Kirsh
Next Extent Consulting
-Original Message-
Sent: Friday, May 17, 2002 5:23 PM
To: Multiple recipients of list
32 matches
Mail list logo