// I have inserted 1000001 record in task1 collection with below script


var insertT = function() {
    var start = (new Date()).getTime();
    for (var i=0; i< 1000001; i++) {
        db.task1.insert({"user" : "Coldsky", "finished" : i, "unfinished" : 1000001 - i})
    }
    var end  = (new Date()).getTime();
    var diff = end -start;
    print("Insert 1M documents took " + diff + "ms" )
    }
    
> insertT()

// I have performed below queries in query analyzer
   (Note - ADS default setting)


select count(*) from task1

SELECT FLATTEN * FROM "task1" limit 100000
GO

SELECT FLATTEN * FROM "task1" limit 200000
GO



SELECT FLATTEN "_id", "user", "finished", "unfinished" 
	FROM "task1" limit 100000
GO

SELECT FLATTEN "_id", "user", "finished", "unfinished" 
	FROM "task1" limit 200000
GO


select * from task1 where unfinished = 99234
go

select * from task1 where finished = 99234
go

delete from task1 where finished = 99233
go


UPDATE task1 
	SET "user" = 'AAAAAAA'
	WHERE finished = 99234
GO

select * from "task1" where finished = 99234 OR unfinished = 99333
go