Re: WHERE 1=2 with performance nightmares

Del Murray wrote:

Randomizing doesn't solve the problem because most of the time we do
this to get an "initialized" empty recordset which we can append
records into.

You can combine the two to guarantee an empty result set without the
risk of a full scan.

--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Want to help make Delphi and InterBase better? Use QC!
http://qc.borland.com -- Vote for important issues
.

Relevant Pages

  • Re: Sorting recordsets
    ... > ' Create an empty recordset for the results ... > .Append "accountCount", adBigInt ... > .Append "latestOrderDate", adDate ... > I populate it with rows. ...
    (microsoft.public.data.ado)
  • Sorting recordsets
    ... ' Create an empty recordset for the results ... set oRSResults = CreateObject ... .Append "accountCount", adBigInt ... .Append "latestOrderDate", adDate ...
    (microsoft.public.data.ado)