Re: oracle vs sybase cheatsheet

Oh yeah ... just removed it actually.  Now that i've been in
Oracle land for a while, i removed/corrected several things just now.
(the questions at the bottom really).

Literaly, I wrote that back in 2001 after being in-oracle for 2
weeks ... it was the only way I could survive :-)

Its funny; one thing I've noticed in my Oracle time is the prevalent
number of "Oracle Myths" that exist out there.  Example, we just had
yet another huge discussion about whether count(*) or count(1) is
better or worse: a classic oracle myth that one is better than the other.

The index thing apparently is another myth that is still out there.
Someone told me that once, and I believed it b/c i didn't know any
better.  I'm sure thats how a lot of bad theories get passed around.

Someone could make a mint just writing a "Myth-debunking" book on
Oracle.  Wait a minute!  What a grand Idea!  :-)

todd

> 
> Todd:
> Thanks very much!
> That will get me going, and I very much appreciate it.
> 
> I did run across your "oracle cheatsheet" when I
> googled, and it's quite useful.
> 
> I would recommend that you remove Theresa's statement
> 
> "Another concern is that Oracle never deletes from
> indexes, so you have to
> rebuild your indexes periodically to reclaim space
> from deletes.]"
> 
> since it is inaccurate and might cause a dba to do
> something they might not want to do.
> 
> Again, thanks for your assistance!
> 
> Barb
> 
> 
> --- tboss@xxxxxxxxxxxxxxxxxx wrote:
> > I'm coming the reverse way, actually.  I've found no
> > similar reference book out there.
> > 
> > I have a pseudo-cheasheat online at:
> >
> http://www.bossconsulting.com/oracle_dba/oracle.cheatsheet
> > 
> > Though, its probably inaccurate in some areas.  I've
> > been fully in Oracle for a while
> > and should probably do some updating.
> > 
> 
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> 

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: