Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Empty table - many extents

Empty table - many extents

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 12 Aug 2003 11:56:05 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7040F9CFE@lnewton.leeds.lfs.co.uk>


Hi Nuno,

>> Hmmmm. If I replace all my SQL by "select * from dual",
>> do you think I'll end up with an optimised and tuned database
>> as well? Or should I use bind variables?
>> <d&r, vvf>

Only if you have indexed dual :o)

Cheers,
Norm.



Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------
Received on Tue Aug 12 2003 - 05:56:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US