Re: Do you ever have days where you dont want to think ?
as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Re: Do you ever have days where you dont want to think ?
Stephane, I *did* warn you about the OT list before I approved your registration on it.. btw, this sounds like it should have gone private, not to the list Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Do you ever have days where you dont want to think ?
Hehe... I was thinking the same thing and decided not to pursue! Thanks for stepping up to make that request. I don't look like a man, I don't feel like a man, have never been called one of the guys Just curious too... This is interesting! Melanie Burns -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 9:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http
Re: Do you ever have days where you dont want to think ?
This inquiring mind want's to know, what is honorary about being thought of as a man instead of the women you are? Ruth. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 10:23 AM as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat
RE: Do you ever have days where you dont want to think ?
How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Do you ever have days where you dont want to think ?
[EMAIL PROTECTED] wrote: as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel Well, coming from me 'honorary man' is almost a compliment (also perhaps not totally in the context of nude sunbathing - I would not be totally opposed to chador in some cases on French beaches). What summarizes my thought best, and in a better way than I am able to put it, is probably this : http://www.geocities.com/Broadway/Stage/4575/mflaudrey7.html#A Now I think I'd better run for cover, even if the trouble-and-strife is not on the list ... You asked for it ;-). -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
RE: Do you ever have days where you dont want to think ?
If we told you, we would have to kill you ;P You will need to be a registered user of Yahoo (have a Yahoo logon/password). Go to: http://groups.yahoo.com/group/oracle-l-ot And click join this group. You will then be prompted for info such as how you want to receive the messages etc.. HTH Mark a.k.a Dorothy a.k.a Mutant Metabolism Boy -Original Message- Robert Sent: 20 May 2002 17:34 To: Multiple recipients of list ORACLE-L How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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
RE: Do you ever have days where you dont want to think ?
One makes a large cash offering to the Oracle Goddess... -Original Message- Sent: Monday, May 20, 2002 12:34 PM To: Multiple recipients of list ORACLE-L How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat
Re: Do you ever have days where you dont want to think ?
oh I never said it was an honor to be considered a man. --- Ruth Gramolini [EMAIL PROTECTED] wrote: This inquiring mind want's to know, what is honorary about being thought of as a man instead of the women you are? Ruth. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 10:23 AM as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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
RE: Do you ever have days where you dont want to think ?
it's joe's list --- Grabowy, Chris [EMAIL PROTECTED] wrote: One makes a large cash offering to the Oracle Goddess... -Original Message- Sent: Monday, May 20, 2002 12:34 PM To: Multiple recipients of list ORACLE-L How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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
RE: Do you ever have days where you dont want to think ?
All you men on this list really need to get out more!! ;-) -Original Message- Sent: Monday, May 20, 2002 12:39 PM To: Multiple recipients of list ORACLE-L we want jpegs !!! :-) -Original Message- Sent: 20 May 2002 17:03 To: Multiple recipients of list ORACLE-L Hehe... I was thinking the same thing and decided not to pursue! Thanks for stepping up to make that request. I don't look like a man, I don't feel like a man, have never been called one of the guys Just curious too... This is interesting! Melanie Burns -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 9:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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
Re: Do you ever have days where you dont want to think ?
But the original poster and some of the others seem to think that this would be an honor...RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 1:33 PM oh I never said it was an honor to be considered a man. --- Ruth Gramolini [EMAIL PROTECTED] wrote: This inquiring mind want's to know, what is honorary about being thought of as a man instead of the women you are? Ruth. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 10:23 AM as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858
RE: Do you ever have days where you dont want to think ?
What is 'get out more'? -Original Message- Sent: Monday, May 20, 2002 12:39 PM To: Multiple recipients of list ORACLE-L All you men on this list really need to get out more!! ;-) -Original Message- Sent: Monday, May 20, 2002 12:39 PM To: Multiple recipients of list ORACLE-L we want jpegs !!! :-) -Original Message- Sent: 20 May 2002 17:03 To: Multiple recipients of list ORACLE-L Hehe... I was thinking the same thing and decided not to pursue! Thanks for stepping up to make that request. I don't look like a man, I don't feel like a man, have never been called one of the guys Just curious too... This is interesting! Melanie Burns -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 9:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Do you ever have days where you dont want to think ?
Sigh no more, ladies, sigh nor more; Men were deceivers ever; One foot in sea and one on shore, To one thing constant never; Then sigh not so, But let them go, And be you blithe and bonny; Converting all your sounds of woe Into. Hey nonny, nonny. Sing no more ditties, sing no mo, Or dumps so dull and heavy; The fraud of men was ever so, Since summer first was leavy. Then sigh not so, But let them go, And be you blithe and bonny, Converting all your sounds of woe Into. Hey, nonny, nonny. Thank you, Paul Sherman DBAElcom, Inc. email - [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 1:34 PM To: Multiple recipients of list ORACLE-L oh I never said it was an honor to be considered a man. --- Ruth Gramolini [EMAIL PROTECTED] wrote: This inquiring mind want's to know, what is honorary about being thought of as a man instead of the women you are? Ruth. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 10:23 AM as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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
RE: Do you ever have days where you dont want to think ?
Yeah, so. I would think for the right amount of money, he would put on a wig and dress... -Original Message- Sent: Monday, May 20, 2002 1:54 PM To: Multiple recipients of list ORACLE-L it's joe's list --- Grabowy, Chris [EMAIL PROTECTED] wrote: One makes a large cash offering to the Oracle Goddess... -Original Message- Sent: Monday, May 20, 2002 12:34 PM To: Multiple recipients of list ORACLE-L How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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
Re: Do you ever have days where you dont want to think ?
ah but who says Henry Higgins was right? --- Stephane Faroult [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel Well, coming from me 'honorary man' is almost a compliment (also perhaps not totally in the context of nude sunbathing - I would not be totally opposed to chador in some cases on French beaches). What summarizes my thought best, and in a better way than I am able to put it, is probably this : http://www.geocities.com/Broadway/Stage/4575/mflaudrey7.html#A Now I think I'd better run for cover, even if the trouble-and-strife is not on the list ... You asked for it ;-). -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
RE: Do you ever have days where you dont want to think ?
ROFL -- this whole thread has kept me cracking up all morning !!! -- (Mrs.) JoJo :D -Original Message- Paul R. Sent: Monday, May 20, 2002 11:35 AM To: Multiple recipients of list ORACLE-L Sigh no more, ladies, sigh nor more; Men were deceivers ever; One foot in sea and one on shore, To one thing constant never; Then sigh not so, But let them go, And be you blithe and bonny; Converting all your sounds of woe Into. Hey nonny, nonny. Sing no more ditties, sing no mo, Or dumps so dull and heavy; The fraud of men was ever so, Since summer first was leavy. Then sigh not so, But let them go, And be you blithe and bonny, Converting all your sounds of woe Into. Hey, nonny, nonny. Thank you, Paul Sherman DBAElcom, Inc. email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JoJo Al-Zawawi 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).
Re: Do you ever have days where you dont want to think ?
Sherman, Paul R. wrote: Sigh no more, ladies, sigh nor more; Men were deceivers ever; One foot in sea and one on shore, To one thing constant never; Then sigh not so, But let them go, And be you blithe and bonny; Converting all your sounds of woe Into. Hey nonny, nonny. Sing no more ditties, sing no mo, Or dumps so dull and heavy; The fraud of men was ever so, Since summer first was leavy. Then sigh not so, But let them go, And be you blithe and bonny, Converting all your sounds of woe Into. Hey, nonny, nonny. Thank you, Paul Sherman DBAElcom, Inc. email - [EMAIL PROTECTED] One woman is fair, yet I am well; another is wise, yet I am well; another virtuous, yet I am well; but till all graces be in one woman, one woman shall not come in my grace. Rich she shall be, that's certain; wise, or I'll none; virtuous, or I'll never cheapen her; fair, or I'll never look on her; mild, or come not near me; noble, or not I for an angel; of good discourse, an excellent musician, and her hair shall be of what colour it please God. Time to move to the OT list, perhaps. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
Re: Do you ever have days where you dont want to think ?
My favorite Shakespearean (sp?) play and yes, I think we should move this to the OT list :) --- Stephane Faroult [EMAIL PROTECTED] wrote: Sherman, Paul R. wrote: Sigh no more, ladies, sigh nor more; Men were deceivers ever; One foot in sea and one on shore, To one thing constant never; Then sigh not so, But let them go, And be you blithe and bonny; Converting all your sounds of woe Into. Hey nonny, nonny. Sing no more ditties, sing no mo, Or dumps so dull and heavy; The fraud of men was ever so, Since summer first was leavy. Then sigh not so, But let them go, And be you blithe and bonny, Converting all your sounds of woe Into. Hey, nonny, nonny. Thank you, Paul Sherman DBAElcom, Inc. email - [EMAIL PROTECTED] One woman is fair, yet I am well; another is wise, yet I am well; another virtuous, yet I am well; but till all graces be in one woman, one woman shall not come in my grace. Rich she shall be, that's certain; wise, or I'll none; virtuous, or I'll never cheapen her; fair, or I'll never look on her; mild, or come not near me; noble, or not I for an angel; of good discourse, an excellent musician, and her hair shall be of what colour it please God. Time to move to the OT list, perhaps. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
RE: Do you ever have days where you dont want to think ?
Try sending message to: [EMAIL PROTECTED] On Mon, 2002-05-20 at 11:33, Freeman, Robert wrote: How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858
RE: Do you ever have days where you dont want to think ?
-Original Message- In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). There was a time when I used that approach. Not talking about MINUS in general since I still find cases for that, but flipping a NOT IN / NOT EXISTS into an IN or EXISTS sitting on top of a MINUS in a sub-query, just like in your example (except you used an in-line view): select a.f1, a.f2, a.f3, a.f4 from (select f1 from table1 minus select n1 from b) a2, table1 a where a.f1 = a2.f1 But this was back in 5, 6, and early 7 and I had to use a sub-query since in-line views weren't there yet (7.2, officially?). And though the in-line view gives us more join methods to choose from, I still haven't been able to produce a case where it was the best. The biggest thing I see is the double hit on table1 (table scan or it's indexes (full or fast full)). May have had something to do with the way CBO handle NOTS back in the earlier versions? NOT real sure. Anyway, I remember a long time ago recommending the above (but using a sub-query). And I think it was Tim Sawmiller who asked why the heck I did it that way. I said because it's faster than a NOT IN / NOT EXISTS. He asked for an example, and I couldn't provide one. His point was well taken (we were up to V7 by then and I'm guessing pre 7.2 since I didn't try the in-line view route). In fact, someone else also recommended the approach, and he had asked both of us to provide an example, and neither one of us could make it the faster approach. So yeah, I started to re-think that approach. FWIW, I had to tune a package not too long ago that used the construct above for all their anti-joins. Most were running for minutes, anywhere from 5 minutes to 30 minutes. Going to a NOT IN (with always_anti_join set to hash) dropped all of them to a matter of seconds (and I think I had to go to a correlated NOT EXISTS on a couple others due to their nature, and the outer join null key for a couple of others since they didn't meet the requirement for a hash-aj). But knowing the technique above has been useful in the past, I have tried on several occasions to build test cases where it beat all other approaches. I haven't been able to build one. Obviously that doesn't mean there aren't cases where it could be the best, maybe just my lack of successfully thinking of and building a case where it would be the best. So, I am still curious if there are still conditions, and what those conditions are, where that approach is the best. I just haven't been able to come up with one -- maybe another sign of my aging and losing my faculties. But at least I didn't work on V4 or prior like some of the *really* old folks on the list ;-) Larry G. Elkins [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins 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).
Re: Do you ever have days where you dont want to think ?
Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
RE: Do you ever have days where you dont want to think ?
It's not using the index because of the NOT IN - it doesn't help to search an index to see what's NOT in it. Did you try rewriting it to use a NOT EXISTS instead? Gary Gary Kirsh Next Extent Consulting -Original Message- Sent: Friday, May 17, 2002 5:23 PM To: Multiple recipients of list ORACLE-L I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue. I have a query that looks like this ... select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); there is a primary key index on b.n1 there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1 the query shows that the index is being used on table b, but no indexes are being used on table a. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kirsh, Gary 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).
RE: Do you ever have days where you dont want to think ?
-- Kirsh, Gary [EMAIL PROTECTED] It's not using the index because of the NOT IN - it doesn't help to search an index to see what's NOT in it. Did you try rewriting it to use a NOT EXISTS instead? Which can quickly degenerate into a tablescan also... even if the index exists if the entropy isn't high enough oracle will skip it anyway. Try an analyze table first on the exists (or a sub-query) and see how that works. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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).
Re: Do you ever have days where you dont want to think ?
Johnson, Michael wrote: I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue. I have a query that looks like this ... select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); there is a primary key index on b.n1 there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1 the query shows that the index is being used on table b, but no indexes are being used on table a. Mike I don't think that lying naked on a beach would help, but hints and the like could. I presume that table1 is pretty big. Larry Elkins could tell you that the HASH_AJ hint inside the subquery could work wonders. Another usually efficient solution (which in facts often boils down to the same thing as the hash anti-join hint in terms of execution plan) would be select a.f1, a.f2, a.f3, a.f4 from table1 a, b where a.f1 = b.n1 (+) and b.n1 is null Something else which could be contemplated if f1 is indexed could be select a.f1, a.f2, a.f3, a.f4 from (select f1 from table1 minus select n1 from b) a2, table1 a where a.f1 = a2.f1 Might require the ORDERED hint. I cannot tell you 'this is the best', depends on volumes searched and volumes returned, but one of those things might work well in your case. And ignore any advice to use NOT EXISTS unless you have an additional pretty selective condition on table1. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
RE: Do you ever have days where you dont want to think ?
Try... select a.f1, a.f2, a.f3, a.f4 from table1 a where not exists (select b.n1 from b where b.n1 = a.f1); Let me know... Chris -Original Message- Sent: Friday, May 17, 2002 5:23 PM To: Multiple recipients of list ORACLE-L I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue. I have a query that looks like this ... select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); there is a primary key index on b.n1 there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1 the query shows that the index is being used on table b, but no indexes are being used on table a. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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).
RE: Do you ever have days where you dont want to think ?
I'm not sure an index would ever be used with not in (in seems to be bad enough). Not exists would probably be quicker though it'd probably be reasonable still to do a full table scan of a. Personally I prefer the likes of minus though it'd be a bit convoluted here e.g. select a.f1, a.f2, a.f3, a.f4 from a, (select a.f1 from table1 a minus select b.n1 from b) s where a.f1 = s.f1 -Original Message- Sent: Friday, May 17, 2002 10:23 PM To: Multiple recipients of list ORACLE-L I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue. I have a query that looks like this ... select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); there is a primary key index on b.n1 there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1 the query shows that the index is being used on table b, but no indexes are being used on table a. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicoll, Iain (Calanais) 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).
RE: Do you ever have days where you dont want to think ?
Title: RE: Do you ever have days where you dont want to think ? Mike, WheretheheckisOLN-AFMC? Okie City? Anyway, it seems to me that the non-unique index on a.f1 is a waste of space as a.f1 is the first field of the primary key index. Have you tried a hint? select /*+ index(table1 Table1_PK_indexname) */ a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); My assumption is that you have a performance problem. How many records and how long does it take? Maybe show us the entire explain plan? Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Johnson, Michael [SMTP:[EMAIL PROTECTED]] I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue. I have a query that looks like this ... select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); there is a primary key index on b.n1 there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1 the query shows that the index is being used on table b, but no indexes are being used on table a. Mike
Re: Do you ever have days where you dont want to think ?
Yeah, I have those days. The beach sounds good; don't worry, I'll go find my own. Wouldn't want to frighten the natives. Try 'not exists', 'not in' forces a table scan. Even better, use an explicit anti-join. select a.f1, a.f2, a.f3, a.f4 from table1 a, table2 b where a.f1 = b.n1(+) and b.n1 is null; I learned this from Larry Elkins, I *think* I did it properly. Rather clever I thought. Jared Johnson, Michael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/17/2002 02:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Do you ever have days where you dont want to think ? I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue. I have a query that looks like this ... select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); there is a primary key index on b.n1 there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1 the query shows that the index is being used on table b, but no indexes are being used on table a. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Do you ever have days where you dont want to think ?
Sorry I dont want to think!! -Original Message- Sent: Friday, May 17, 2002 5:23 PM To: Multiple recipients of list ORACLE-L I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue. I have a query that looks like this ... select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); there is a primary key index on b.n1 there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1 the query shows that the index is being used on table b, but no indexes are being used on table a. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed 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).
Re: Do you ever have days where you dont want to think ?
Don't have time to help with the query but following this link may help with the first part: http://images.google.com/images?hl=enlr=q=naked+beach (you military guys, one tract minds...lol) Brian P. MacLean Oracle DBA, OCP8i Johnson, Michael Michael.Johnson@oln-aTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fmc.af.mil cc: Sent by: Subject: Do you ever have days where you dont want to think ? [EMAIL PROTECTED] 05/17/02 02:23 PM Please respond to ORACLE-L I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue. I have a query that looks like this ... select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); there is a primary key index on b.n1 there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1 the query shows that the index is being used on table b, but no indexes are being used on table a. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Do you ever have days where you dont want to think ?
The beach part sounds great, though I don't care to see naked men running around ;-) But it still beats doing this techie thing all the time. FWIW, a NOT IN *can* use an index under the CBO, and has done so since early 7, behaving very much like a correlated NOT EXISTS with a slight difference for nulls handling. Then in 7.3.2 when you could hint a hash_aj, or, set always_anti_join to hash (or merge), it could drift away from a correlated approach, using a hash or merge anti-join, *if* that was the appropriate approach. Maybe using an FTS, or an index fast full scan, or an index full scan. And whether to correlate or not depends on the data and the query, it's criteria, data, etc. And the MINUS operator is always an option that works well in some cases. The outer join and key is null trick that Stephane and Jared showed can be *very* useful. I can't remember where I first saw that trick, but I know Guy Harrison's SQL Tuning book, first edition, discusses it. I had seen it prior to that, but Harrison's book is at least one reference to the technique that I know of. And there are quite a few people who use the trick. It is especially useful when you *don't* want a correlated approach but the requirement for being able to use a hash-aj can't be met -- I had to use it on Thursday. Dropped that baby from 38 minutes to under a minute using the outer join and key is null trick along with a hash join outer approach. 9i is interesting because while the NOT EXISTS uses the correlated approach in 8i and earlier, which, depending upon the case, may or may not be a killer on performance, 9i can un-correlate it and use a hash-aj (or merge-aj), *if appropriate*. This isn't possible in 8i or below. So, it can very well take both a NOT EXISTS and NOT IN and make them hash-aj's. I hope the CBO makes the right decision for us ;-) Right now on a DW and a few DM's I deal with on 8.1.7, always_anti_join is set to hash -- that way if I want a correlated approach I use the NOT EXISTS. If the correlated approach is *not* the best approach, I can use a NOT IN and let the hash-aj come into play. Ok, off to the travel web sites, you folks got me thinking about beaches, islands, and water. Oh well, here is an example of a NOT EXISTS getting the hash-aj treatment under 9i: SQL select * 2 from code_master 3 where not exists (select null 4from code_detail 5where code_master.code = code_detail.code) 6 / Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=770 Card=100 Bytes=1500) 10 HASH JOIN (ANTI) (Cost=770 Card=100 Bytes=1500) 21 TABLE ACCESS (FULL) OF 'CODE_MASTER' (Cost=77 Card=10 Bytes=110) 31 INDEX (FAST FULL SCAN) OF 'CD_CODE_IDX' (NON-UNIQUE) (Cost=208 Card=299600 Bytes=1198400) Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Friday, May 17, 2002 5:53 PM To: Multiple recipients of list ORACLE-L Subject: Re: Do you ever have days where you dont want to think ? Yeah, I have those days. The beach sounds good; don't worry, I'll go find my own. Wouldn't want to frighten the natives. Try 'not exists', 'not in' forces a table scan. Even better, use an explicit anti-join. select a.f1, a.f2, a.f3, a.f4 from table1 a, table2 b where a.f1 = b.n1(+) and b.n1 is null; I learned this from Larry Elkins, I *think* I did it properly. Rather clever I thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins 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).
