what is faster to do in oracle?
noam gariani
ddf
On Nov 25, 6:09 pm, noam gariani <noamgari...@gmail.com> wrote:
> update? or inserts?
They can both be equally as fast or equally as slow.
David Fitzjarrell
Ashwani Kamboj
I Think insert is always fasster compares to Update
Thanks and rgds
Ashwani Kamboj
--
You received this message because you are subscribed to the Google Groups "ORACLE_DBA_EXPERTS" group.
To post to this group, send email to oracle_db...@googlegroups.com.
To unsubscribe from this group, send email to oracle_dba_expe...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/oracle_dba_experts?hl=en.
ddf
On Dec 10, 7:18 am, Ashwani Kamboj <kamboj.ashw...@gmail.com> wrote:
> I Think insert is always fasster compares to Update
>
> Thanks and rgds
> Ashwani Kamboj
>
>
>
> On Mon, Dec 7, 2009 at 11:01 PM, ddf <orat...@msn.com> wrote:
>
> > On Nov 25, 6:09 pm, noam gariani <noamgari...@gmail.com> wrote:
> > > update? or inserts?
>
> > They can both be equally as fast or equally as slow.
>
> > David Fitzjarrell
>
> > --
>
> > You received this message because you are subscribed to the Google Groups
> > "ORACLE_DBA_EXPERTS" group.
> > To post to this group, send email to oracle_db...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > .
>
> - Show quoted text -
Yet you provide absolutely no proof to support your claim.
Prove your statement with examples.
David Fitzjarrell
Mubashir Ahmad
to enter data inside the object .if
On Dec 10 2009, 8:44 pm, ddf <orat...@msn.com> wrote:
> On Dec 10, 7:18 am, Ashwani Kamboj <kamboj.ashw...@gmail.com> wrote:
>
> > I Think insert is always fasster compares to Update
>
> > Thanks and rgds
> > Ashwani Kamboj
>
> > On Mon, Dec 7, 2009 at 11:01 PM, ddf <orat...@msn.com> wrote:
>
> > > On Nov 25, 6:09 pm, noam gariani <noamgari...@gmail.com> wrote:
> > > > update? or inserts?
>
> > > They can both be equally as fast or equally as slow.
>
> > > David Fitzjarrell
>
> > > --
>
> > > You received this message because you are subscribed to the Google Groups
> > > "ORACLE_DBA_EXPERTS" group.
> > > To post to this group, send email to oracle_db...@googlegroups.com.
> > > To unsubscribe from this group, send email to
> > > oracle_dba_expe...@googlegroups.com<oracle_dba_experts%2Bunsubs cr...@googlegroups.com>
> > > .
> > > For more options, visit this group at
> > >http://groups.google.com/group/oracle_dba_experts?hl=en.-Hide quoted text -
jgar the jorrible
On Feb 4, 8:05 am, Mubashir Ahmad <mubashirahma...@gmail.com> wrote:
> i guess both are equal in both DML cases the major operation is same
> to enter data inside the object .if
I guess you are wrong. But why guess when you can set up a test and
look at the trace? Don't forget to add lots of indices and have many
concurrent sessions working on the same data, and don't forget about
mass inserts above the high water mark, and force logging.
And what about merge? Bulk inserts?
It depends on what question is really being asked. TIMTOWTDI.
jg
--
@home.com is bogus.
http://arstechnica.com/business/news/2010/01/how-a-stray-mouse-click-choked-the-nyse-cost-a-bank-150k.ars
Mubashir Ahmad
problem....you can only have a guess for such
question my dear because no scenario was given to ofcource it depends
on many thing of u analyz there algorithms you will came to know about
there working machanism...
> @home.com is bogus.http://arstechnica.com/business/news/2010/01/how-a-stray-mouse-click-...
ddf
On Feb 6, 3:04 pm, Mubashir Ahmad <mubashirahma...@gmail.com> wrote:
> well my answer to his question was incomplete because of some
> problem....you can only have a guess for such
> question my dear because no scenario was given to ofcource it depends
> on many thing of u analyz there algorithms you will came to know about
> there working machanism...
>
> > On Feb 4, 8:05 am, Mubashir Ahmad <mubashirahma...@gmail.com> wrote:
>
> > > i guess both are equal in both DML cases the major operation is same
> > > to enter data inside the object .if
>
> - Show quoted text -
Honestly, no, you need not guess at such questions as test cases can
be presented to cover most, if not all, scenarios. It's obvious you
don't understand the mechanisms else you'd have taken them into
consideration with your 'guesses'. What does the PCTFREE/PCTUSED
mechanism introduce to the insert scenario? What does using ASSM
attempt to mitigate? The /*+ append */ hint can improve insert speed
by doing what? What is row chaining/migration and how can that affect
updates and inserts? How does the process time using MERGE compare to
the time requried for 'regular' insert/update operations? All of
those scenarios can be tested in minimal time to see if they truly
consume the same time and resources to complete, yet you elected to
simply post your 'best guess' and then defend your chosen course of
action by 'breast beating' and empty rhetoric. Since you 'boiled
down' both insert and update tasks into the mere aspect of 'entering
data inside the object' it's clear you're lacking in such knowledge.
Posting 'problem' or not your basic premise was, and remains, wrong
and no amount of hollow 'bush beating' nor lame excuses can justify
your making such a statement.
David Fitzjarrell