rolympia_at_hotmail.com (Romeo Olympia) wrote in message news:<42fc55dc.0409222319.6038cbca_at_posting.google.com>...
> Hmmm, your first update approach (SQL 1) should have worked nicely.
> Tried simulating it using my own test table (in 9i) and this type of
> update with analytics shouldn't pose any problem.
>
> Your table stats accurate? Mind if we look at the execution plan?
>
SQL 1 is not a practical solution becuase it will run for each row,
including the rank function over the entire calendar table.
Pratap
Received on Thu Sep 23 2004 - 23:19:43 CDT
