Skip to Main Content
  • Questions

  • Select row count with multiple conditions and having 10 million rows

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, vinod.

Asked: June 01, 2017 - 7:20 am UTC

Last updated: June 02, 2017 - 3:15 am UTC

Version: 11 g

Viewed 1000+ times

You Asked

Hi Tom, I have a table and having 10+ million rows. I am getting the count of the table with specific conditions and execution takes 10 secs. I have used "SELECT COUNT(1)" statement and "MAX(ROWNUM)" statement. both statements are taking time. could you please give me an advice to get result quickly.

Thanks in advance.
Regards,
Vinod

and Connor said...

Let me phrase it this way.

"It takes me too long to get to work in the morning. Please solve"

Let's see how you go with that.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.