cancel
Showing results for 
Search instead for 
Did you mean: 

MDO is returning "select count(*) from MDO****"

0 Kudos

Hi All,

Has anybody faced this situation - we are using MDO table in our application and found behind the scene it is firing lot's of "Select count(*) from MDO*****". This count(*) query not used in the application. DBA found it( which SQL query has been executed so far) using  SQLPLUS.  Is there anything inside the MDO code which implicitly call the count(*) query ?

Anyone experienced anything like this ever?

Thanks!

Prahlad

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Prahlad,

    The select count(*) statement is executed internally by the MDO objects when ever they are loaded, copied or any operation is done on/in them. These logs are also visible in the Open SQL monitor screen in NWA.

   Which MII version are you on? If you are 14.0 SP1 or above, these calls have been minimized to a great extent.

Regards,

Tufale Ashai.

0 Kudos

Thanks! for your reply.

We are using 12.2.

~Prahlad

Former Member
0 Kudos

I am not too sure if it is minimized in MII 12.2 as done in  14.0.

However, If this is hampering the performance of your business logic then I would suggest you to raise a ticket,

Regards

Tufale Ashai