You are here |
dioncho.wordpress.com | ||
| | | |
leonotes.wordpress.com
|
|
| | | | ????????transitive closure?Wiki??????????Oracle????????... | |
| | | |
tanelpoder.com
|
|
| | | | I was running tests on some very large tables on an Exadata cluster and found an interesting bug. Instead of having to query 4Billion row tables, I have reproduced this case with a cartesian join Check this. Im generating 8 Billion rows using a 3-way cartesian join of set of 2000 rows. So, this results in 2000 * 2000 * 2000 rows, which is 8 billion rows. SQL> with sq as (select null from dual connect by level <= 2000) select count(*) from sq a, sq b, sq c; COUNT(*) ---------- 8000000000 Everything worked... | |
| | | |
antognini.ch
|
|
| | | | ||
| | | |
dbtimewizard.com.br
|
|
| | Como alterar plano de execução sem alterar o código da aplicação utilizando o recurso "SQL PLAN MANAGEMENT". |