RE: Worlds largest Data Warehouse ?
- From: "Peter McLarty" <p.mclarty@xxxxxxxxxx>
- To: <davidsharples@xxxxxxxxx>, <rajendra.pande@xxxxxxx>
- Date: Fri, 19 Oct 2007 09:01:06 +1000
Actually it has a lot to do with Oracle, Yes So what Sybase could load a
very big DW, what they dont show is when they were doing the queries,
what was there transaction isolation level.
Default of SQlRemeber that due to the infinitely different locking
mechanism that they would have likey needed to set transaction read
uncommitted to be able to get performance in this case.
SQL Server during updates doesn't use omly row level locking, due the
its behaviour, it may eventually escalate to a
________________________________
From: David Sharples [mailto:davidsharples@xxxxxxxxx]
Sent: Friday, 19 October 2007 07:35 AM
To: rajendra.pande@xxxxxxx
Cc: exriscer@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Worlds largest Data Warehouse ?
Whats the point you are trying to make? And what has it got to do with
Oracle?
On 18/10/2007, rajendra.pande@xxxxxxx <rajendra.pande@xxxxxxx> wrote:
No look at the document at
http://www.sybase.com/files/Product_Overviews/Ready-Time-Report_R1.2-090
407.pdf
Other related posts:
