There is a simple soql query ‘select id, name from opportunity’ which fetches millions of records without any selection criterion. How do we optimize the performance of this simple query without using any selection criterion ?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Salesforce Interview Questions

Explain apex code execution governors and limits?

0 Answers  


What is force.com?

0 Answers  


How many certifications are available in salesforce?

0 Answers  


What is mvc architecture in visualforce?

0 Answers  


Explain any scenario occurred you to work beyond governor limits?

0 Answers  






What should be done to override the governor limit that restricts you from fetching more than 50,000 records in a soql query ?

0 Answers  


Difference between soql & sosl?

0 Answers  


Explain bucket fields?

0 Answers  


Write a trigger to insert a contact and user when the account is created?

0 Answers  


How is SaaS beneficial to Salesforce?

0 Answers  


What services are provided by the cloud giant Force.com?

0 Answers   B-Ways TecnoSoft,


What is group by?

0 Answers  


Categories