SELECT x FROM DUAL is bad for system performance?

From: Thomas Jeff <ThomasJe_at_tce.com>
Date: Thu, 13 Dec 2001 06:10:05 -0800
Message-ID: <F001.003DBBFE.20011213060020@fatcity.com>

On page 92 of Oracle Performance Tuning 101, there's a recommendation to avoid the use of SELECT X FROM DUAL, claiming that it can '..use up system performance in a hurry', but does not go on to elaborate as to exactly *why*.

Could someone shed a bit more light on this?   Thanks.

---

Jeffery D Thomas
DBA
Thomson Information Services
Thomson multimedia Inc.

Email: thomasje_at_tce.com
DBA Quickplace: http://gkmqp.tce.com/tis_dba

---

  Received on Thu Dec 13 2001 - 08:10:05 CST