Explore >> Select a destination
|
You are here 
|
dioncho.wordpress.com | ||
| | | | |
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
|
|
| | | | | ||
| | | | |
use-the-index-luke.com
|
|
| | | | | ??????????????????????????????????GROUP BY?????????????????????? | |
| | | | |
www.xt-r.com
|
|
| | | ?????? ????? ???? ????? ?? 11.2.0.3 ? ?????? ??????(V$SQL_HINT), ????? ?????? ?? ???????? ? ???? ??????? ???????, ??????? ??????????? ??????... | ||
