In documentation it is mentioned that “SHOW SCANS” aql query gives “List running primary index (PI) queries (formerly known as scans):”
If I do not specify a where clause in my query , then It is not using a primary key index but instead scanning the whole set. Then why “show scans” documentation mentions that it returns PI queries ?
If you specify a WHERE clause, then it uses the corresponding SECONDARY index for the query, not the primary index. A scan always uses the primary index, and now is renamed as a Primary Index (PI) query. The new name should make it clear that the primary index is used, and also a scan is a type of a query, which is a neutral term used in databases for data retrieval.