Skip to Main Content
  • Questions

  • which approach should i apply to fetch 6 millions records from select statement from various table

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Nitin.

Asked: January 10, 2018 - 11:42 am UTC

Last updated: January 18, 2018 - 1:52 pm UTC

Version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

Viewed 1000+ times

You Asked

I have one requirement where i needs to fetch all the Install base records along with other details.currently in our system there are 6 millions are exist.So please help us to choose better approach for this.

and Connor said...

select * 
from   base_records,
       other_details 
where  base_records.key = other_details.key


I'm not really sure what you expect us to say here....

Rating

  (1 rating)

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

Comments

Need more details.

Ragav, January 16, 2018 - 1:25 pm UTC

Please let me know what you have tried out and whether it worked out or not or did not get the expected results ?. If you have tried something out already, then how much time it did take ? Also, please post details about the tables like key columns, indexes.
Chris Saxon
January 18, 2018 - 1:52 pm UTC

Indeed.
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.

More to Explore

SQL

The Oracle documentation contains a complete SQL reference.