Re: Problema Oracle Visual Basic 6.0

Article View: chile.comp.programacion

Article #911

Back to chile.comp.programacion Previous Next

#911

From: claudio.torres
Date: Thu, 24 May 2007 19:09

20 lines
2087 bytes

Respondo.

La consulta debiera traer como resultado como maximo 30 registros de
una tabla que posee 5 millones de registros app. El tema de indices y
eso debiera estar bien, pq nunca habia fallado solo ahora, y ya
revisamos los indices y estadisticas y está todo bien

este es el plan (Costo 6!!!)

Operation	Object Name	Rows	Bytes	Cost	Object Node	In/Out	PStart	PStop

SELECT STATEMENT Optimizer Mode=ALL_ROWS		1  	 	6
  NESTED LOOPS		1  	61  	6
    NESTED LOOPS		1  	37  	5
      TABLE ACCESS BY INDEX ROWID	TAB1	1  	25  	4
        INDEX RANGE SCAN	DEEV_PRAC_FK_I	1  	 	3
      TABLE ACCESS BY INDEX ROWID	TAB2	1  	12  	1
        INDEX UNIQUE SCAN	PRAC_PK	1  	 	0
    TABLE ACCESS BY INDEX ROWID	TAB3	1  	24  	1
      INDEX UNIQUE SCAN	ATENEA.ACTD_PK	1  	 	0

Technical Details

Message-ID: <1180033764.752883.260380@q75g2000hsh.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!q75g2000hsh.googlegroups.com!not-for-mail

References: <1179953394.226318.127100@o5g2000hsb.googlegroups.com> <f32t2j$3fj$1@news.nivel5.cl>

Show Full Headers

Complete Article Headers

X-Google-Thread: 1593cb,94f563ea40189b2d
X-Google-Attributes: gid1593cb,public,usenet
X-Google-Language: SPANISH,ASCII
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!q75g2000hsh.googlegroups.com!not-for-mail
From: "claudio.torres@gmail.com" <claudio.torres@gmail.com>
Newsgroups: chile.comp.programacion
Subject: Re: Problema Oracle Visual Basic 6.0
Date: 24 May 2007 12:09:24 -0700
Organization: http://groups.google.com
Lines: 22
Message-ID: <1180033764.752883.260380@q75g2000hsh.googlegroups.com>
References: <1179953394.226318.127100@o5g2000hsb.googlegroups.com>
   <f32t2j$3fj$1@news.nivel5.cl>
NNTP-Posting-Host: 200.27.84.2
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1180033765 14600 127.0.0.1 (24 May 2007 19:09:25 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 24 May 2007 19:09:25 +0000 (UTC)
In-Reply-To: <f32t2j$3fj$1@news.nivel5.cl>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.8.0.11) Gecko/20070312 Firefox/1.5.0.11,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: q75g2000hsh.googlegroups.com; posting-host=200.27.84.2;
   posting-account=g3NJrg0AAAB68HEP0qsKwQOMWC19uKC3

Reply to Parent Message