RE: METALINK and OWS

Rolling On Floor Laughing - Another ROFLMAO - You guess=2E=2E

-----Original Message-----

From:	MIME :dmathura_at_neal-and-massy=2Ecom=20=
Sent:	13 June 2000 00:16
To:	ORACLE-L_at_fatcity=2Ecom
Subject:	Re: METALINK and OWS

Nicholas,

Also do remember that Oracle creates indexes to enforce primary/unique key constraints=2E

P=2ES=2E
OK Jared, what does ROFL stands for?

Jared Still wrote:

> ROFL!
>
> ' But Rachel Carmichael said to drop them! '
>
> Jared
>
> On Sun, 11 Jun 2000, Rachel Carmichael wrote:
>
> > WHOA! Slow down before you drop the indexes=2E Indexes are not totally
> > useless! It very much depends on the queries you run against your=20=
database=2E
> > If you are doing a mixture of queries, where some return single rows or a
> > very small subset of data, and some return a large number of rows, you=20=
still
> > should keep the indexes for the first type of query=2E
> >
> > Rachel
> >
> >
> > >From: Nicholas Tufar <ntufar_at_chemist=2Egen=2Etr>
> > >Reply-To: ORACLE-L_at_fatcity=2Ecom
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity=2Ecom>
> > >Subject: Re: METALINK and OWS
> > >Date: Sun, 11 Jun 2000 14:17:51 -0800
> > >
> > > >
> > > > Nicholas,
> > > >
> > > > Sorry=2E=2E=2E I thought most people knew this=2E Oracle says that if a q=
uery
> > >will
> > > > return more than 20% of the rows of a table, it will use a full table
> > >scan=2E
> > > > So you DON'T tune it to use an index=2E In fact, as of 8i, I believe
> > >Oracle
> > > > now recommends that if a query returns as little as 3-5% of a table,=20=
a
> > >full
> > > > table scan is the way to go=2E
> > >
> > >A very valuable piece of information=2E How did I miss it!
> > >Now I know what I am going to do on Monday=2E I had a feeling that
> > >all those indeces are useless, now I know why they are=2E
> > >Thank you very much=2E
> > >
> > >Nicholas
> > >--
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity=2Ecom (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from)=2E You may
> also send the HELP command for other information (like subscribing)=2E

--
   Dev Anand Mathura
   Management Information Systems
   61-63 Edward Street, PO Box 544
   Port-of-Spain, Trinidad, W=2EI=2E
   phone: (868) 627-4203, fax: (868) 624-8569
   e-mail: dmathura_at_neal-and-massy=2Ecom


-- Author: Dev Mathura
  INET: dmathura_at_neal-and-massy=2Ecom

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity=2Ecom (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from)=2E  You may
also send the HELP command for other information (like subscribing)=2E