--- title: AQL Functions Improvements - ArangoDB description: "Waiting for a git pull to complete over an 8 KiB/s internet connection is boring. So I thought I’d rather use the idle time and quickly write about some performance improvements for certain AQL functions that were recently completed and that will become available with ArangoDB 2.6. The improvements affect the following AQL functions: UNSET():…" --- ArangoDB 3.12 Product Release Announcement! Read the blog for details. [Read Blog](https://arangodb.com/2024/03/arangodb-3-12-performance-for-all-your-data-models/) [![logo](https://blog.arangodb.com/hs-fs/hubfs/Imported_Blog_Media/logo.png?width=301&height=50&name=logo.png "logo")](https://arango.ai) ### Why Graph [The Rise of Graph](https://arangodb.com/the-rise-of-graph/) [The Graph ML Gamechanger](https://arangodb.com/the-graph-ml-gamechanger/) [Consolidate to Graph](https://arangodb.com/graph-vs-relational/) [Graph DB Basics](https://arangodb.com/graph-database/) ### Products [Managed Graph DB](https://arangodb.com/arangograph-managedgraphdb/) [Self-Managed Graph DB](https://arangodb.com/arangograph-selfmanaged/) [Managed Graph ML](https://arangodb.com/managed-ml-graph/) [Community Edition](https://arangodb.com/community-server/) [Compare Products](https://arangodb.com/subscriptions/) ### Solutions Use Cases Industries Solution Accelerators - [Cyber/Threat Mgmt](https://arangodb.com/solutions/use-cases/cyber-threat-management/) - [Fraud Detection](https://arangodb.com/solutions/use-cases/fraud-detections/) - [Supply Chain](https://arangodb.com/solutions/use-cases/supply-chain/) - [Network Asset Management](https://arangodb.com/solutions/use-cases/network-asset-management/) - [Customer & Patient 360](https://blog.arangodb.com/solutions/use-case/customer-and-patient-360/) - [Recommendations](https://arangodb.com/solutions/use-cases/recommendations/) - [Case Management](https://blog.arangodb.com/solutions/use-case/case-management/) - [Geospatial Analysis](https://arangodb.com/solutions/use-cases/geospatial/) - [Master Data Mgmt](https://arangodb.com/solutions/use-cases/master-data-management/) - [Software & Technology](https://arangodb.com/arangodb-for-software-tech/) - [Financial Services](https://arangodb.com/arangodb-for-financial-services/) - [Tele Communication](https://arangodb.com/telecommunications-and-network/) - [E-commerce](https://arangodb.com/arangodb-for-e-commerce/) - [Healthcare](https://arangodb.com/arangodb-for-healthcare/) - [Government](https://arangodb.com/arangodb-for-government/) - [Aerospace & Defence](https://arangodb.com/arangodb-for-aerospace-defense/) - [Manufacturing](https://arangodb.com/arangodb-for-manufacturing/) - [Enterprise Knowledge Graphs](https://arangodb.com/resources/white-papers/enterprise-knowledge-graphs/) - [Entity Resolution](https://arangodb.com/entity-resolution/) - [Traceability/Lineage](https://arangodb.com/traceability-and-lineage/) - [Contexual Relevance](https://arangodb.com/contextual-relevance/) ### Developers Capabilities Integrations Differentiators - [Graph Traversals](https://arangodb.com/graph-traversals/) - [Multi-Model DB](https://arangodb.com/multi-model-db/) - [LLM + Knowledge Graph](https://arangodb.com/llm-knowledge-graph/) - [Graph ML](https://arangodb.com/managed-ml-graph/) - [Advanced Geospatial](https://arangodb.com/advanced-geospatial/) - [Document Store](https://arangodb.com/document-store/) - [Search Engine](https://arangodb.com/full-text-search-engine/) - [Security & Compliance](https://arangodb.com/security/) - [Data Masking](https://arangodb.com/Data-masking/) - [Key/Value DB](https://arangodb.com/integrated-key-value-support/) - [Clients / Languages](https://arangodb.com/clients-languages/) - [BI Tools](https://arangodb.com/bi-tools-support/) - [Containers](https://arangodb.com/container-support/) - [Community driven](https://arangodb.com/community-driven/) - [Model Flexibility](https://arangodb.com/model-flexibility/) - [Graph Scalability](https://arangodb.com/graph-scalability/) - [Performance at Scale](https://arangodb.com/performance-at-scale/) - [Highest Availability](https://arangodb.com/highest-availability/) - [Unified Query Language](https://arangodb.com/unified-query-languageaql/) - [Graph + Native Document](https://arangodb.com/graph-document/) - [Graph + Native Search](https://arangodb.com/graph-search/) - [Cost Effective](https://arangodb.com/cost-effective-development-operation/) - [Full Geospatial](https://arangodb.com/full-geospatial/) ### Customers [All Case Studies](https://arangodb.com/solutions/solutions-customers/#all) [Government & Cyber](https://arangodb.com/solutions/solutions-customers/#Government-Cyber) [Manufacturing & Supply Chain](https://arangodb.com/solutions/solutions-customers/#Manufacturing-Supply-Chain) [Healthcare & Science](https://arangodb.com/solutions/solutions-customers/#Healthcare-Science) [Retail & Commerce](https://arangodb.com/solutions/solutions-customers/#Retail-Commerce) [Technology](https://arangodb.com/solutions/solutions-customers/#Technology) [Education](https://arangodb.com/solutions/solutions-customers/#Education) [Telco](https://arangodb.com/solutions/solutions-customers/#Telco) [Financial Services](https://arangodb.com/solutions/solutions-customers/#Financial-Services) ### Learn [Documentation](https://docs.arangodb.com/stable/) [Developer Hub](https://developer.arangodb.com/) [ArangoDB University](https://university.arangodb.com/) [Blog](https://arangodb.com/blog/) [Certification](https://arangodb.com/learn/certification/) [Community](https://arangodb.com/community/) [Events](https://arangodb.com/events/) [Resources](https://arangodb.com/resources/) [Training Center](https://arangodb.com/learn/) ### Company [About Us](https://arangodb.com/about-us/) [Team](https://arangodb.com/about-arangodb/) [Partners](https://arangodb.com/partners/) [News](https://arangodb.com/news/) [Careers](https://arangodb.applytojob.com/apply) ### Pricing - Why Graph - [The Rise of Graph](https://arangodb.com/the-rise-of-graph/) - [The Graph ML Gamechanger](https://arangodb.com/the-graph-ml-gamechanger/) - [Consolidate to Graph](https://arangodb.com/graph-vs-relational/) - [Graph DB Basics](https://arangodb.com/graph-database/) - Products - [Managed Graph DB](https://arangodb.com/arangograph-managedgraphdb/) - [Self-Managed Graph DB](https://arangodb.com/arangograph-selfmanaged/) - [Managed Graph ML](https://arangodb.com/managed-ml-graph/) - [Community Edition](https://arangodb.com/community-server/) - [Compare Products](https://arangodb.com/subscriptions/) - Solutions - Use Cases - [Cyber/Threat Mgmt](https://arangodb.com/solutions/use-cases/cyber-threat-management/) - [Fraud Detection](https://arangodb.com/solutions/use-cases/fraud-detections/) - [Supply Chain](https://arangodb.com/solutions/use-cases/supply-chain/) - [Network Asset Management](https://arangodb.com/solutions/use-cases/network-asset-management/) - [Customer & Patient 360](https://arangodb.com/solutions/use-cases/customer-and-patient-360/) - [Recommendations](https://arangodb.com/solutions/use-cases/recommendations/) - [Case Management](https://arangodb.com/solutions/use-cases/case-management/) - [Geospatial Analysis](https://arangodb.com/solutions/use-cases/geospatial/) - [Master Data Mgmt](https://arangodb.com/solutions/use-cases/master-data-management/) - Industries - [Software & Technology](https://arangodb.com/arangodb-for-software-tech/) - [Financial Services](https://arangodb.com/arangodb-for-financial-services/) - [Tele Communication](https://arangodb.com/telecommunications-and-network/) - [E-commerce](https://arangodb.com/arangodb-for-e-commerce/) - [Healthcare](https://arangodb.com/arangodb-for-healthcare/) - [Government](https://arangodb.com/arangodb-for-government/) - [Aerospace & Defence](https://arangodb.com/arangodb-for-aerospace-defense/) - [Manufacturing](https://arangodb.com/arangodb-for-manufacturing/) - Solution Accelerators - [Enterprise Knowledge Graphs](https://arangodb.com/resources/white-papers/enterprise-knowledge-graphs/) - [Entity Resolution](https://arangodb.com/entity-resolution/) - [Traceability/Lineage](https://arangodb.com/traceability-and-lineage/) - [Contexual Relevance](https://arangodb.com/contextual-relevance/) - Customers - [All Case Studies](https://arangodb.com/solutions/solutions-customers/#all) - [Government & Cyber](https://arangodb.com/solutions/solutions-customers/#Government-Cyber) - [Manufacturing & Supply Chain](https://arangodb.com/solutions/solutions-customers/#Manufacturing-Supply-Chain) - [Healthcare & Science](https://arangodb.com/solutions/solutions-customers/#Healthcare-Science) - [Retail & Commerce](https://arangodb.com/solutions/solutions-customers/#Retail-Commerce) - [Technology](https://arangodb.com/solutions/solutions-customers/#Technology) - [Education](https://arangodb.com/solutions/solutions-customers/#Education) - [Telco](https://arangodb.com/solutions/solutions-customers/#Telco) - [Financial Services](https://arangodb.com/solutions/solutions-customers/#Financial-Services) - Learn - [Documentation](https://docs.arangodb.com/stable/) - [Developer Hub](https://developer.arangodb.com/) - [ArangoDB University](https://university.arangodb.com/) - [Blog](https://arangodb.com/blog/) - [Certification](https://arangodb.com/learn/certification/) - [Community](https://arangodb.com/community/) - [Events](https://arangodb.com/events/) - [Resources](https://arangodb.com/resources/) - [Training Center](https://arangodb.com/learn/) - Company - [About Us](https://arangodb.com/about-us/) - [Team](https://arangodb.com/about-arangodb/) - [Partners](https://arangodb.com/partners/) - [News](https://arangodb.com/news/) - [Careers](https://arangodb.applytojob.com/apply) - [Pricing](https://arangodb.com/download-major/pricing/) [**Start Free** ArangoGraph Cloud](https://dashboard.arangodb.cloud/signup?acceptedTermsAndConditions=1) [**Download Now** ArangoDB Enterprise](https://arangodb.com/download-arangodb-enterprise/) ![Vector-5](https://blog.arangodb.com/hubfs/Imported_Blog_Media/search.svg) # AQL Functions Improvements April 23, 2015 Tags: [AQL](https://blog.arangodb.com/blog/topic/aql), [General](https://blog.arangodb.com/blog/topic/general) [Twitter](https://twitter.com/intent/tweet?url=https://blog.arangodb.com/blog/2015/04/aql-functions-improvements) [LinkedIn](http://www.linkedin.com/shareArticle?mini=true&url=https://blog.arangodb.com/blog/2015/04/aql-functions-improvements) [Reddit](https://www.reddit.com/share?url=https://blog.arangodb.com/blog/2015/04/aql-functions-improvements) [Yahoo](https://plus.google.com/share?url=https://blog.arangodb.com/blog/2015/04/aql-functions-improvements%3Futm_medium%3Dsocial%26utm_source%3Dgoogle_plus) ![](https://blog.arangodb.com/hubfs/ArangoDB-Blog/clock.svg)Estimated reading time: 1 minutes Waiting for a `git pull` to complete over an 8 KiB/s internet connection is boring. So I thought I’d rather use the idle time and quickly write about some performance improvements for certain AQL functions that were recently completed and that will become available with ArangoDB 2.6. The improvements affect the following AQL functions: - `UNSET()`: remove specified attributes from an object/document - `KEEP()`: keep only specified attributes of an object/document - `MERGE()`: merge the attributes of multiple objects/documents This blog post shows a few example queries that will benefit from **50 to more than 60 % reductions** in query execution times due to the changes done to these functions. Please read the full blog post [AQL Functions Improvements](http://jsteemann.github.io/blog/2015/04/23/aql-functions-improvements/). [Twitter](https://twitter.com/intent/tweet?url=https://blog.arangodb.com/blog/2015/04/aql-functions-improvements) [LinkedIn](http://www.linkedin.com/shareArticle?mini=true&url=https://blog.arangodb.com/blog/2015/04/aql-functions-improvements) [Reddit](https://www.reddit.com/share?url=https://blog.arangodb.com/blog/2015/04/aql-functions-improvements) [Yahoo](https://plus.google.com/share?url=https://blog.arangodb.com/blog/2015/04/aql-functions-improvements%3Futm_medium%3Dsocial%26utm_source%3Dgoogle_plus) ![Picture of Jan Steemann](https://blog.arangodb.com/hubfs/Imported_Blog_Media/Authors/Jan-Steemann-100x100.webp) April 23, 2015 , [Jan Steemann](https://blog.arangodb.com/blog/author/jan-steemann) After more than 30 years of playing around with 8 bit computers, assembler and scripting languages, Jan decided to move on to work in database engineering. Jan is now a senior C/C++ developer with the ArangoDB core team, being there from version 0.1. He is mostly working on performance optimization, storage engines and the querying functionality. He also wrote most of AQL (ArangoDB’s query language). ### Leave a Comment Tags - [General](https://blog.arangodb.com/blog/topic/general) - [Release](https://blog.arangodb.com/blog/topic/release) - [Community](https://blog.arangodb.com/blog/topic/community) - [Releases](https://blog.arangodb.com/blog/topic/releases) - [Performance](https://blog.arangodb.com/blog/topic/performance) - [Tutorial](https://blog.arangodb.com/blog/topic/tutorial) - [Foxx](https://blog.arangodb.com/blog/topic/foxx) - [AQL](https://blog.arangodb.com/blog/topic/aql) - [API](https://blog.arangodb.com/blog/topic/api) - [Newsletter](https://blog.arangodb.com/blog/topic/newsletter) - [Cluster](https://blog.arangodb.com/blog/topic/cluster) - [Graph](https://blog.arangodb.com/blog/topic/graph) - [Graphs](https://blog.arangodb.com/blog/topic/graphs) - [Documentation](https://blog.arangodb.com/blog/topic/documentation) - [Javascript](https://blog.arangodb.com/blog/topic/javascript) - [Query Language](https://blog.arangodb.com/blog/topic/query-language) - [Architecture](https://blog.arangodb.com/blog/topic/architecture) - [NoSQL](https://blog.arangodb.com/blog/topic/nosql) - [Enterprise](https://blog.arangodb.com/blog/topic/enterprise) - [Ruby](https://blog.arangodb.com/blog/topic/ruby) - [RocksDB](https://blog.arangodb.com/blog/topic/rocksdb) - [testing](https://blog.arangodb.com/blog/topic/testing) - [ArangoML](https://blog.arangodb.com/blog/topic/arangoml) - [Machine Learning](https://blog.arangodb.com/blog/topic/machine-learning) - [Benchmark](https://blog.arangodb.com/blog/topic/benchmark) - [Java](https://blog.arangodb.com/blog/topic/java) - [driver](https://blog.arangodb.com/blog/topic/driver) - [multi-model](https://blog.arangodb.com/blog/topic/multi-model) - [geo](https://blog.arangodb.com/blog/topic/geo) - [how to](https://blog.arangodb.com/blog/topic/how-to) - [Drivers](https://blog.arangodb.com/blog/topic/drivers) - [PHP](https://blog.arangodb.com/blog/topic/php) - [Security](https://blog.arangodb.com/blog/topic/security) - [nodejs](https://blog.arangodb.com/blog/topic/nodejs) - [python](https://blog.arangodb.com/blog/topic/python) - [ArangoSearch](https://blog.arangodb.com/blog/topic/arangosearch) - [Kubernetes](https://blog.arangodb.com/blog/topic/kubernetes) - [Presentation](https://blog.arangodb.com/blog/topic/presentation) - [open-source](https://blog.arangodb.com/blog/topic/open-source) - [Future-of-nosql](https://blog.arangodb.com/blog/topic/future-of-nosql) - [GitHub](https://blog.arangodb.com/blog/topic/github) - [ARM: Raspberry + Co.](https://blog.arangodb.com/blog/topic/arm-raspberry-co-) - [Fraud Detection](https://blog.arangodb.com/blog/topic/fraud-detection) - [Managed Service](https://blog.arangodb.com/blog/topic/managed-service) - [arangosh](https://blog.arangodb.com/blog/topic/arangosh) - [C++](https://blog.arangodb.com/blog/topic/c) - [Cloud](https://blog.arangodb.com/blog/topic/cloud) - [Conferences](https://blog.arangodb.com/blog/topic/conferences) - [Data Science](https://blog.arangodb.com/blog/topic/data-science) - [HTTP](https://blog.arangodb.com/blog/topic/http) - [ML](https://blog.arangodb.com/blog/topic/ml) - [Pregel](https://blog.arangodb.com/blog/topic/pregel) - [Replication](https://blog.arangodb.com/blog/topic/replication) - [WebUI](https://blog.arangodb.com/blog/topic/webui) - [graph database](https://blog.arangodb.com/blog/topic/graph-database) - [monitoring](https://blog.arangodb.com/blog/topic/monitoring) - [pytorch](https://blog.arangodb.com/blog/topic/pytorch) - [Application Server](https://blog.arangodb.com/blog/topic/application-server) - [ArangoGraphML](https://blog.arangodb.com/blog/topic/arangographml) - [Community Edition](https://blog.arangodb.com/blog/topic/community-edition) - [Compliance](https://blog.arangodb.com/blog/topic/compliance) - [Linux](https://blog.arangodb.com/blog/topic/linux) - [Publication](https://blog.arangodb.com/blog/topic/publication) - [Relational Database](https://blog.arangodb.com/blog/topic/relational-database) - [SOC 2](https://blog.arangodb.com/blog/topic/soc-2) - [Windows](https://blog.arangodb.com/blog/topic/windows) - [licensing](https://blog.arangodb.com/blog/topic/licensing) - [networkx](https://blog.arangodb.com/blog/topic/networkx) - [storage](https://blog.arangodb.com/blog/topic/storage) - [ARM](https://blog.arangodb.com/blog/topic/arm) - [Alliances](https://blog.arangodb.com/blog/topic/alliances) - [ArangoDB Cloud](https://blog.arangodb.com/blog/topic/arangodb-cloud) - [ArangoSync](https://blog.arangodb.com/blog/topic/arangosync) - [Arangograph](https://blog.arangodb.com/blog/topic/arangograph) - [CNFC](https://blog.arangodb.com/blog/topic/cnfc) - [DC/OS](https://blog.arangodb.com/blog/topic/dc-os) - [DGL Adaptor](https://blog.arangodb.com/blog/topic/dgl-adaptor) - [Data Loader](https://blog.arangodb.com/blog/topic/data-loader) - [Dev Days 2021](https://blog.arangodb.com/blog/topic/dev-days-2021) - [Developer Hub](https://blog.arangodb.com/blog/topic/developer-hub) - [Funding Announcement](https://blog.arangodb.com/blog/topic/funding-announcement) - [GO](https://blog.arangodb.com/blog/topic/go) - [GenAI](https://blog.arangodb.com/blog/topic/genai) - [Graph DB](https://blog.arangodb.com/blog/topic/graph-db) - [Graph DBs](https://blog.arangodb.com/blog/topic/graph-dbs) - [Graph Databases](https://blog.arangodb.com/blog/topic/graph-databases) - [Graph Neural Networks](https://blog.arangodb.com/blog/topic/graph-neural-networks) - [GraphDB](https://blog.arangodb.com/blog/topic/graphdb) - [Inside ArangoDB](https://blog.arangodb.com/blog/topic/inside-arangodb) - [Intel](https://blog.arangodb.com/blog/topic/intel) - [Intel PyG](https://blog.arangodb.com/blog/topic/intel-pyg) - [Intel Xeon CPU](https://blog.arangodb.com/blog/topic/intel-xeon-cpu) - [KG](https://blog.arangodb.com/blog/topic/kg) - [Knowledge Graphs](https://blog.arangodb.com/blog/topic/knowledge-graphs) - [LLM](https://blog.arangodb.com/blog/topic/llm) - [Large Language Models](https://blog.arangodb.com/blog/topic/large-language-models) - [Migrate to Graph](https://blog.arangodb.com/blog/topic/migrate-to-graph) - [NetworkX Adaptor](https://blog.arangodb.com/blog/topic/networkx-adaptor) - [Oasis](https://blog.arangodb.com/blog/topic/oasis) - [Partners](https://blog.arangodb.com/blog/topic/partners) - [PyG](https://blog.arangodb.com/blog/topic/pyg) - [PyTorch Geometric](https://blog.arangodb.com/blog/topic/pytorch-geometric) - [RDF](https://blog.arangodb.com/blog/topic/rdf) - [Series B](https://blog.arangodb.com/blog/topic/series-b) - [adapter](https://blog.arangodb.com/blog/topic/adapter) - [analytics](https://blog.arangodb.com/blog/topic/analytics) - [analyzers](https://blog.arangodb.com/blog/topic/analyzers) - [arangopipe](https://blog.arangodb.com/blog/topic/arangopipe) - [atomics](https://blog.arangodb.com/blog/topic/atomics) - [aws](https://blog.arangodb.com/blog/topic/aws) - [collaboration](https://blog.arangodb.com/blog/topic/collaboration) - [concurrency](https://blog.arangodb.com/blog/topic/concurrency) - [dev days](https://blog.arangodb.com/blog/topic/dev-days) - [fuzzy search](https://blog.arangodb.com/blog/topic/fuzzy-search) - [graphsage](https://blog.arangodb.com/blog/topic/graphsage) - [licence](https://blog.arangodb.com/blog/topic/licence) - [memory model](https://blog.arangodb.com/blog/topic/memory-model) - [plugin](https://blog.arangodb.com/blog/topic/plugin) - [preprocessing](https://blog.arangodb.com/blog/topic/preprocessing) - [recommendation](https://blog.arangodb.com/blog/topic/recommendation) - [resource description framework](https://blog.arangodb.com/blog/topic/resource-description-framework) - [semantic web](https://blog.arangodb.com/blog/topic/semantic-web) - [torch](https://blog.arangodb.com/blog/topic/torch) - [turtle](https://blog.arangodb.com/blog/topic/turtle) - [x86](https://blog.arangodb.com/blog/topic/x86) - [— Relational Database](https://blog.arangodb.com/blog/topic/-relational-database) [![logo](https://blog.arangodb.com/hs-fs/hubfs/Imported_Blog_Media/logo.png?width=301&height=50&name=logo.png "logo")](https://arango.ai) ArangoGraph Insights Platform Accelerate application innovation and performance with our next-generation graph data and analytics platform. - - - - - #### Quick Links - [Quick Start](https://docs.arangodb.com/3.11/) - [Roadmap](https://arangodb.com/roadmap/) - [Language Drivers](https://docs.arangodb.com/3.11/develop/drivers/) - [Case Studies](https://arangodb.com/solutions/solutions-customers/#all) - [BI Connectors](https://arangodb.com/community-driven/bi-connector-arangodb/) - [Certification Exam](https://arangodb.com/learn/certification/) #### Info - [Community](https://arangodb.com/community/) - [Events](https://arangodb.com/events) - [Online Meetup](https://www.meetup.com/online-ArangoDB-meetup/) - [Logo/Resources](https://arangodb.com/resources/logos/) - [Stackoverflow](https://stackoverflow.com/questions/tagged/arangodb) - [Slack](https://join.slack.com/t/arangodb-community/shared_invite/zt-2d4p43cma-flyf72j9a9wq4A2OtuMFkA) #### About Us - [About Us](https://arangodb.com/about-us/) - [Jobs](https://arangodb.applytojob.com/apply) - [Imprint](https://arangodb.com/imprint/) - [Contact Us](https://arangodb.com/contact/) - [News](https://arangodb.com/news/) - [Google Groups](https://groups.google.com/g/arangodb) #### Stay In Touch Keep up with the latest news from the ArangoDB ©2023 ArangoDB. All Rights Reserved. [Terms & Conditions](https://cloud.arangodb.com/terms-and-conditions)|[Our Privacy Policy](https://cloud.arangodb.com/privacy-policy) ![](https://www.facebook.com/tr?id=336858843477853&ev=PageView&noscript=1)