<div>
No. unfortunately this is not possible. You have to change the code to either count(1) or count(row_id). <br />
<br />
count(*) will definitely take lot more time if you have a long field in the table.
</div>


No. unfortunately this is not possible. You have to change the code to either count(1) or count(row_id).

count(*) will definitely take lot more time if you have a long field in the table.

<div>
You can also think of increasing PARALLEL_EXECUTION_MESSAGE<wbr />_SIZE or DB_FILE_MULTIBLOCK_READ_CO<wbr />UNT=0, therefore while doing Parallelism or fulltable scan oracle will read more resp.
</div>


You can also think of increasing PARALLEL_EXECUTION_MESSAGE_SIZE or DB_FILE_MULTIBLOCK_READ_COUNT=0, therefore while doing Parallelism or fulltable scan oracle will read more resp.

<div>
Can you do explain plan on that particular SQL (select count(*))? I'd expect to see Index FFS if you've an index on any of those fields. Like the above post it should read the INDEX to get the count and that should be fast. Did you check you stat? Is it up to date? 
</div>


Can you do explain plan on that particular SQL (select count(*))? I'd expect to see Index FFS if you've an index on any of those fields. Like the above post it should read the INDEX to get the count and that should be fast. Did you check you stat? Is it up to date?

<div>
virdi_ds<br />
Adding primary key did it thank you
</div>


virdi_ds
Adding primary key did it thank you

<div>
<div class="content wysiwyg-content">
Select count(*) is taking some time in oracle to run. This could is in a vendor enterprise system and they can not change the code to select count(row_id) with out sending us a new update. Is there a way to trick the database to intreprite select count(*) from mytable to select count(row_id) from mytable. This table has long datatype. I tried to do a shrink in the test database &nbsp;but it will not let you &nbsp;
</div>
</div>


Select count(*) is taking some time in oracle to run. This could is in a vendor enterprise system and they can not change the code to select count(row_id) with out sending us a new update. Is there a way to trick the database to intreprite select count(*) from mytable to select count(row_id) from mytable. This table has long datatype. I tried to do a shrink in the test database  but it will not let you  

oracle Select count(*)

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.