Well, you can do it efficiently as you like, but if the data is to be historically accurate on a writeable table then if we are recording
SELECT * FROM foobar
it is likely to require a copy of foobar at the time of the query, or doing amazing things with the transaction log. I agree this would be a programming tour de force, but I question its utility.
alt Hacker News
Well, you can do it efficiently as you like, but if the data is to be historically accurate on a writeable table then if we are recording
it is likely to require a copy of foobar at the time of the query, or doing amazing things with the transaction log. I agree this would be a programming tour de force, but I question its utility.