"Mikael Osterhed" <moster_no_spam_67_at_hotmail.com> wrote in message
news:tZqh9.1857$Av4.37051_at_twister2.libero.it...
<SNIP>
> However I am also a programmer (Visual Basic - yes I know...but it is
> fast and time is money for most companies) and I have always wondered
"what
> is the source-code like for a (any) database. With help of SQL I am able
to
> interrogate, let loose scripts etc but what does a database do with my
> SQL-statements internally. I guess it receives my statements and then
> treat/translate these through its calls and functions.
I guess there are two things you could instructively do.
- Trace a few sql statements with the optimisers decision path enabled.
This can tell you quite a lot (if you can read it!)
- Look at the source for an open source database.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Tue Sep 17 2002 - 10:30:54 CDT
