Re: Empty table - many extents

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA7040F9CFE_at_lnewton.leeds.lfs.co.uk...

> >> 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)
>

I have! It shows up in USER_INDEXES.
Together with a bunch of other stuff
I don't understand. Do you think if I
drop all that garbage and use more of those "tablespace" thingies my queries might go faster?
I never had this problem with MySQL or
Postgres...

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam