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 -> Re: doubt on table scan

Re: doubt on table scan

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Wed, 19 Oct 2005 21:12:28 -0700
Message-ID: <IZqdnYUQmOFJhcrenZ2dnUVZ_sidnZ2d@comcast.com>

<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

Original text of this message

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