Viewing 9 posts - 1 through 9 (of 9 total)
(grins a sly grin) By the way - there is one more part called "the application" I never restore them myself but I hear tell that a database with...
December 14, 2012 at 11:14 am
Backups have only given me grief. Its restores that count & make me look good.
However I have gotten burned with "level of expectation"
1) A dual...
December 10, 2012 at 7:50 am
Gail,
Hi. No its me thinking of Oracle where one tries to match the page size to the physical disk so things are read in cosecutive sectors.
...
January 23, 2009 at 2:49 pm
Pages, clustering, processing, fragmentation and disk implimentaion.
4k, 8k, 16k, 32k - it depends from what I have been told.
First - the slowest part...
January 23, 2009 at 6:52 am
Gail,
No you are right. Table is something more physical than a view which is more than "a resultset"
They may all be 'tables' but as you...
January 22, 2009 at 2:03 pm
Good point about the Sybase stuff
The "in-memory result set" - is that a table ?
Not a physical table kept on disk, just a set...
January 22, 2009 at 9:32 am
Gail,
Hi. Yes there is a temporary internal table for the resultant set rows that the cursor runs against I believe
(Source sybase which was SQL 6.0, 6.5 and 7.0...
January 22, 2009 at 7:16 am
Hmm, I like the answers but there is so much more.
SQL statement comes in, is parsed, is checked for syntax and authorization against the current database and...
January 20, 2009 at 2:36 pm
Like everyone else has written - it depends.
Look at CPU usage - are you at or over 80%?
Look at DISK time - is it at...
January 20, 2009 at 1:57 pm
Viewing 9 posts - 1 through 9 (of 9 total)