title: Very huge data avoid analytical function
body: <p>Assume there are 100 million distinct SID values in this table.</p>
  
  <p>Example: Table <code>test</code>, columns <code>SID, date_operation, score</code></p>
  
  <p>So in this table, score changes everyday so if I want to get report of all the SID with most recent score. Don't want to use analytical function as otherwise cost would be very high. Tried self join also but looks like that is also costly.</p>
  
  <p>If this question is redundant please direct me to similar question I will delete it.</p>