Hi! I need to query today's sales for some sort of reporting purpose but the table involved has millions of records and takes a lot of time. My solution is that I will query it for some pre-scheduled times during the day and write to a custom table. If I need to to refresh to the latest value, I will query ONLY the NEXT record from the LAST record in my custom table then add them together.
As I was searching for solutions, I came across ORA_ROWSCN pseudocolumn which seems to be the solution to my problem. Is it really the solution or there are some more options available using Oracle standard database features? What happens if some of the previous records where UPDATED/DELETED, how does ora_rowscn behave? Please I need some inputs regarding this.
Thanks.