/explore
|
You are here 
|
savvinov.com | ||
| | | | |
www.dbaglobe.com
A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc. |
|
| | | | | ||
| | | | |
optimizermagic.blogspot.com
Generating and displaying the execution plan of a SQL statement is a common task for most DBAs, SQL developers, and preformance experts as i... |
|
| | | | | ||
| | | | |
kerryosborne.oracle-guy.com
[AI summary] The article discusses techniques for using SQL Profiles to influence query optimization in Oracle databases, building on previous methods like outline switching. |
|
| | | | | ||
| | | | |
tanelpoder.com
Jonathan Lewis has already written about this behavior from the angle of PARALLEL hints. I'm writing a similar article just because the word FORCE in the ALTER SESSION FORCE PARALLEL QUERY syntax. Force should mean that some behavior would always happen (when possible), right? Let's test: SQL> CREATE TABLE t AS SELECT * FROM dba_objects; Table created. SQL> CREATE INDEX i ON t(owner); Index created. SQL> @gts t Gather Table Statistics for table t... PL/SQL procedure successfully completed. Now let's "force" the parallel query in my session, run the query and check the execution plan: - Linux, Oracle, SQL performance tuning and troubleshooting training & writing. |
|
| | | |||
