Bitmaps and reverse indexes

Found a good source of info on stuff I have not fully understood before

reverse indexes

bitmap myths

Star transformations

https://blogs.oracle.com/optimizer/entry/star_transformation

sql developer 4 - ubuntu crahses

The answer turned out to be

ulimit -c unlimited
followed by
unset GNOME_DESKTOP_SESSION_ID

then ./sqldeveloper.sh

https://forum.java.sun.com/thread/260563

materialized view - this article sums up my view of Materialized views

http://oraclesponge.wordpress.com/2006/04/12/a-quick-materialized-view-performance-note/

sql developer CSV hint

Outputs a csv . There are others too.

Tom again

http://www.oracle.com/technetwork/issue-archive/2013/13-jul/o43asktom-1958803.html

More on flashback

flashback table t
to before drop;

NULLs are a bad idea use 'UNKNOWN' cos it gets indexed - another Myth!

I have thought this for a long time and sure enough Tom explains.

http://www.oracle.com/technetwork/issue-archive/2012/12-nov/o62asktom-1867739.html