Couchbase server is taking too much time to execute simple n1ql query

DELETE should work. What is command you are using and how many records it qualifies to delete. You can also give LIMIT option as part of delete. What version of couchbase you are using.

You can try with 4.6.3 or 4.6.4