Search Results

I have dropped order by but no improvement.. any other suggestion?

I am using ndmcli to NDM my files. When i do so it prints success for the process, with out any errors, but file is not reached at destination.
ndmcli -x << EOJ
submit phcdb process...

Sorry i forget to mention, FILEDATA column is the CLOB data. So 3 lakh records which i said before number of lines in this CLOB data not the number of rows in DB (it is just 9 rows). But still...

Hi All,

It takes around one hour to retrieve 3 lakhs data from DB. I feel this can be still more reduced, please help me in improvising the below code, to get it retrieve faster, atleast 30 to 45...