Jared and others,
Oops. I think u guys have problem with HTML formatted
messages. I used that for proper formatting, i had no
idea that it looked so messed up.
I'll care to send it in text format only (or both and
mark them accordingly)
Regards, Naveen
- Jared Still <jkstill_at_cybcon.com> wrote:
>
> Naveen and others,
>
> Does this email appear to be completely unformatted
> to anyone else?
>
> Just wondering if it was formatted when sent, or if
> this happened along
> the way, or is it just me?
>
> I'm not likely to respond to something this
> difficult to read, and I'm just
> wondering if there's a remedy to this.
>
> I've noticed at times that I may send a carefully
> formatted post only to
> have it appear rather messy on the list. This most
> often happens to
> email I send from work using Lotus Notes.
>
> Here at home I use KDE Kmail, which is much easier
> to configure than Lotus.
>
> Sorry for the intrusion, but this appeared to be an
> interesting topic, and
> it's rather tedious to format these so I can read
> them. I can't be the only
> one that recieves mail looking like this.
>
> Thanks,
>
> Jared
>
> On Saturday 02 February 2002 02:50, Naveen Nahata
> wrote:
> > Type ----------------------------- --------
> ----------------- CDL_CDL_ID
> > NOT NULL NUMBER(10) DESCRIPTION
> NOT NULL
> > VARCHAR2(50) DOCUMENT_LINE NOT
> NULL NUMBER(2) DATE_RECEIVED
> > NOT NULL DATE DATE_RETURNED
> DATE
> > INSERTED_BY NOT NULL
> VARCHAR2(30) INSERT_DATE
> > NOT NULL DATE LAST_CHANGED_BY
> NOT NULL VARCHAR2(30)
> > LAST_CHANGE_DATE NOT NULL
> DATEDESCRIPTION column will have
> > relatively few distinct values compared to the
> number of rows so a Bitmap
> > Index will be considered.Following are the 3
> queries which immediately come
> > to my mind ...Query 1:SELECT DISTINCT
> cdl.description FROM cdl_documents
> > cdl WHERE description NOT IN (SELECT description
> FROM
> > cdl_documents WHERE cdl_cdl_id = 5);Query
> 2:SELECT DISTINCT
> > cdl.description FROM cdl_documents cdl WHERE NOT
> EXISTS (SELECT 1
> > FROM cdl_documents WHERE cdl_cdl_id = 5
> AND cdl.description =
> > description);Query 3:SELECT DISTINCT description
> FROM
> > cdl_documentsMINUSSELECT DISTINCT description
> FROM cdl_documents WHERE
> > cdl_cdl_id = 5;One more thing -It is generally not
> advisable to use a NOT
> > IN or NOT EQUAL TO clause for an indexed column
> bcoz the optimizer will go
> > for FULL TABLE SCAN rather than INDEX SCAN. But
> what if i have a Bitmap
> > Index? Will an INDEX SCAN still be avoided? If
> yes, why?Regards, Naveen
> >
> >
> > ---------------------------------
> > Do You Yahoo!?
> > Yahoo! Auctions Great stuff seeking new owners!
> Bid now!
>
> ----------------------------------------
> Content-Type: text/html; charset="us-ascii";
> name="Attachment: 1"
> Content-Transfer-Encoding: 7bit
> Content-Description:
> ----------------------------------------
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.com
>
> 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.com (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). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naveen Nahata
INET: naveen_nahata_at_yahoo.com
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.com (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). You may
also send the HELP command for other information (like subscribing).
Received on Mon Feb 04 2002 - 10:51:48 CST
