Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: doubt on table scan
<yong321_at_yahoo.com> wrote in message
news:1129736026.617967.93940_at_o13g2000cwo.googlegroups.com...
> Hi, Michel,
>
> The query result looks like coming from a parallel query coordinator.
> Was the table altered parallel <a number probably larger than 5> by any
> chance? Can you provide the full SQLs including the SQL that creates
> the tablespace? But I think the most important is how the table is
> created (or altered). What's the block size of the database or
> tablespace, and database version? Thanks.
>
> Yong Huang
>
Don't rely on it. Oracle could change it at any time. While academically
it is interesting, it isn't something you should use to design a system. It
is what I call brittle.
Jim
Received on Wed Oct 19 2005 - 23:12:28 CDT
![]() |
![]() |