Re: Select multiple rows from DUAL ?

Anurag Varma wrote:

> The rows estimation can probably be fixed by using hint
> select /*+ cardinality(t 1) */ user from table(array_t(1)) t;
>
> Anurag

Didn't do it. Still 8168 rows with cost of 24.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---