index ⁽¹⁾

I have a customer with a million row 125mb table. A query they are running returns very slowly: explain plan for SELECT * FROM BIGTABLE WHERE col1 IS NULL; SELECT * FROM TABLE(dbms_xplan.display); -------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |…