Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!feed.tweaknews.nl!postnews.google.com!k39g2000yqe.googlegroups.com!not-for-mail
From: "Gerard H. Pille" <ghpille@hotmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Surprising Performance Changes with Oracle 11.2.0.1 (Long Post)
Date: Wed, 9 Sep 2009 02:48:45 -0700 (PDT)
Organization: http://groups.google.com
Lines: 23
Message-ID: <090a6e0f-6f7b-4d74-997b-088f9ea12e61@k39g2000yqe.googlegroups.com>
References: <1ea99c67-8713-4ece-a0f5-85f66851b016@v2g2000vbb.googlegroups.com> 
 <stydnRbjqr7nYjzXnZ2dnUVZ8nSdnZ2d@bt.com> <20921d95-425c-4a2e-8442-cd075cef541a@q14g2000vbi.googlegroups.com> 
 <5Judncssy_PJDj_XnZ2dnUVZ8uydnZ2d@bt.com> <15629bf2-94c4-48a1-a958-daf0ea47f6ed@j9g2000vbp.googlegroups.com> 
 <7gi1ucF2podgiU1@mid.individual.net> <cf797b90-e06b-4399-813b-e3e9d4fb15bb@e18g2000vbe.googlegroups.com>
NNTP-Posting-Host: 194.78.177.195
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1252489725 30108 127.0.0.1 (9 Sep 2009 09:48:45 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 9 Sep 2009 09:48:45 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: k39g2000yqe.googlegroups.com; posting-host=194.78.177.195; 
 posting-account=sysdUQkAAAA-YCJZgfLqmldcn0o7vIiS
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; 
 rv:1.9.1.1pre) Gecko/20090717 SeaMonkey/2.0b1 Firefox/2.0,gzip(gfe),gzip(gfe)
Xref:  news.cambrium.nl

Hallo Charles,

I'd like to see your statistics for this select:

SELECT /*+ index (t1 ind_t1) */
  ID,
  DESCRIPTION
FROM
  sys.T1 t1
WHERE
  ID >= 9991
/

I suppose you were aware of the skew in the index, but how does this
account for the difference in performance?

On my old PC - with a new disk - the FTS takes 2 minutes, the IS 20
minutes, selecting id between 1 and 400 via index takes over 3 hours.

Kind regards,

Gerard