| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_bossconsulting.com 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_at_freelists.org
> 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
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Jul 15 2004 - 10:21:41 CDT
 |
 |