Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: explain plan assistance needed

Re: explain plan assistance needed

From: <>
Date: Mon, 04 Jun 2007 23:00:16 -0700
Message-ID: <>

SHINE international trade company
Sorry to trouble you.
please read this mail. It's for your career
>From shine international trade Company of Beijing. China
Dear sir/madam:

        Thank you for read this mail. Our company in china. Like you think, china is ready To be world's factory. We have all kinds of things. Of course. We have best manpower resource , best price. More and more person, company like to build trade company in china. It is our predominance. Like light industry, Sinitic things. and a lot of other things need us to do. It's a chance for us. That's right.

        Until this, I want you know, our company now do business about like shoes, bags, belts, clothing, PSP, glasses jeans and so on. Our company want to look for a cooperate friend in your state. If you agree our company case. If you want to pay just a computer to do something. If you have a trade company in your state. Or if you have a shop(online shop)You can call us to talk about next step. We will give the best price, best service. The shine international shine trade will like to talk to you very much.

         You can go to our website to leave massage

	 phone: 86-13811619431
	 FAX: 86-10-51670319
	             GOOD LUCK!
			        								       EVEN FROM CHINA
> If it's a matter of interpretting the resulting trace file to get the
> answers I need then I'll accept I have some reading to do.
> On Jun 4, 11:44 am, wrote:
> > On Mon, 04 Jun 2007 10:03:09 -0700, pfa <> wrote:
> > >I'm struggling to find information that willexplainthe results of my
> > >explainplan. What I'm trying to do is write a verification routine
> > >which shows the benfits of adding an index. From past experience it is
> > >accepted that just creating an index isn't (necessarily) enough but an
> > >analyze table ... compute statistics or a dbms_stats.gather... process
> > >be run. But in my test process theexplainis showing an index scan
> > >without the stats and after the stats the only difference is the
> > >output of the rows/bytes.
> > >Can anybody shed some light on this or point me to a url with some
> > >reading material that explains this?
> > Oracle 10g will just estimate the stats (on every execution) if they
> > lack in the dictionary (see your 'typical' keyword in the init.ora
> > parameters you supplied).
> > Also Oracle will know how much cheaper (or more expensive) a single
> > block read is compared to a multiblock read. This information is being
> > used to compare a FTS vs an index access.
> > However, you would need to run this statement with event 10053 set to
> > get a breakdown of optimiser decisions in a trace file
> > --
> > Sybrand Bakker
> > Senior Oracle DBA- -
> - -
Received on Tue Jun 05 2007 - 01:00:16 CDT

Original text of this message