Community

Choosing Between Oracle’s Bitmap and Function-based Indexes

(David Fitzjarrell) NULL values can be a performance issue as, absent an index of some sort, searching for them involves a full table scan. For small tables (less than 10,000 rows) this usually isn’t a time sink; however, in enterprise tables (with millions of rows) a full table scan can consume con




Tags: