Re: What means my execution plan?

From: sybrandb@xxxxxxxxx
Date: 9 Feb 2006 05:58:09 -0800

1 finish_date is null doesn't use an index by design, as nulls aren't
indexed.
2 you use general_log in your subquery. Your subquery doesn't bear any
resemblance with the log table definition. Do you expect anyone to fill
in the gaps?

--
Sybrand Bakker
Senior Oracle DBA

.

References:
- What means my execution plan?
  - From: grrey

Prev by Date: Re: PACKAGES DEPENDANCE
Next by Date: Business Logic in User Defined Types
Previous by thread: Re: What means my execution plan?
Next by thread: Are you a NO waiting to be Katrinized?
Index(es):
- Date
- Thread

Relevant Pages

Re: Difference between = and IN
... I was under the impression that Nulls would just be excluded from the ... "Hugo Kornelis" wrote: ... > subquery is executed only once. ...
(microsoft.public.sqlserver.mseq)
Re: Select statment
... What happens when you run the query? ... (NOT IN won't return anything if there are NULLs in the subquery) ... SQL Server MVP ...
(microsoft.public.sqlserver.programming)
Re: Not IN or Where Not Exists in subquery?
... You might try creating a subquery that identifies the records you wish ... to exclude, then do a left join to that pulling only the nulls. ... I'm not sure that Access/Jet support "Exists" ...
(comp.databases.ms-access)