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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
