Re: group by clause filling up temp space
Add AND 0 = 1 to the predicate...
Seriously, it is hard to say. At the very least post a full explain
plan (including bytes/card column values).
Is this the only query on the system?
.
Relevant Pages
- Re: Optimizing SQL to Reduce Table Scans
... Even without the plan any suggestions for ... Is this the proper way to conduct this kind of query? ... Prev by Date: ...
(comp.databases.oracle.misc) - Question about an explain plan.
... I got the following explain plan for a query: ... One thing I cannot understand in this plan is that the last step, ... index scan would always return a single rowid. ... Prev by Date: ...
(comp.databases.oracle.server) - Re: Why is this
... would be to have a single index on (lastrecon, acctnum, deposit) [or ... cover the query and handle the restrictive condition immediately. ... there is no perfect query plan. ... use the index for TOP 1, even if it used quite a few bookmark lookups, ...
(microsoft.public.sqlserver.server) - Re: Query optimizer issue
... Consider a stored proc defined as follows: ... when compiling a plan. ... parameter @p1 into the query at compile time before a plan for the query ... execution plans, but a key requirement for everything to work as expected ...
(microsoft.public.sqlserver.server) - Re: Execute SQL UD Function call timeout, 1-3 seconds in query ana
... We did build a little ASP.NET page yesterday that lets us put a given sql ... query into a text box and then return the execution plan (using Showplan_Text ... Query Analyzer. ...
(microsoft.public.dotnet.framework.adonet) |
|
