Re: oracle vs sybase cheatsheet
- From: tboss@xxxxxxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 15 Jul 2004 11:26:50 -0500 (EST)
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 //www.freelists.org/archives/oracle-l/
> FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
