/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 www.xt-r.com
XT&R blackboard: Oracle/?. ?
| | nenadnoveljic.com
Undocumented Implicit Partition Statistics Gathering - All-round Database Topics
21.2 parsecs away

Travel
| | A boundary condition where subpartition statistics gathering can also trigger partition statistics
| | sqlmaria.com
How to use DBMS_STATS DIFF_TABLE_STATS functions
18.9 parsecs away

Travel
| | In 11g, Oracle introduced the DBMS_STAT.DIFF_TABLE_STATS functions to help you compare two sets of statistics for a table along with all its dependent objects (indexes, columns, partitions). There ...
| | timurakhmadeev.wordpress.com
DatabaseMetaData#getIndexInfo() « Timur Akhmadeev's blog
21.6 parsecs away

Travel
| | If you were an Oracle developer and you were asked to implement a small part of the JDBC driver functionality - the getIndexInfo() method of the java.sql.DatabaseMetaData interface - how'd you do that? The API states following requirements: ResultSet getIndexInfo(Stringcatalog, Stringschema, Stringtable, booleanunique, booleanapproximate) throws SQLException Retrieves a description of the given table's indices and...
| | alexzeng.wordpress.com
# Expert Oracle Practices # PL/SQL and the CBO | Alex Zeng's Blog
42.2 parsecs away

Travel
| I am reading Expert Oracle Practices by Oracle Database Administration from the Oak Table. I'd like to summary and share what I learned. This chapter PL/SQL and the CBO by Jo?e Senega?nik is pretty interesting. It tells how to use oracle extensible optimizer to set the selectivity and the cost of PL/SQL functions. This will...