In the previous post we saw date filter clause impact over index, now let us iterate the same testcase against partitioned tables, Table Creation CREATE TABLE "C##HARI"."TBL_OBJECTS_p" ( "ID" NUMBER, "ID_VAL" VARCHAR2(46...
I was discussing with my friend on date filters and how they impact the performance, thought this topic is worth blogging. With tables holding historic data, you would see columns...
Oracle 12c Pattern Matching Big SQL :) Before getting into Oracle 12c Pattern Matching - the set of questions which came across after looking at Oracle 12c Patern Matching -...
The word "Tuning" should be in discussion right at the initial stage of your design and not just after shipping you code to production. In most of the environments have...
The below use case will help to check whether your SQL would be rewritten using particular MV - without having to execute the SQL. Isn't it cool, let us check...
My application front end is Java and DB is Oracle. What array should i use in my PLSQL - program parameters to enable JDBC application to invoke them ? Until...
Until Oracle 12c, we have been using WITH Clause to replace Sub-query Correlated Subqueries Now to this you can define PLSQL declarations in a WITH Clause statement from Oracle 12c....
Transaction--> Locks How is my transaction are tracked How does oracle ensures or rather maintains data integrity and table definition integrity during the due course of my transaction? How is...
Apart from parsing What happens when i issue an update statement ?/li> How does Oracle comply with the properties of a Database Transaction aka ACID properties If interested read further :)...