Read selected columns (performance optimization)

By default, all column values are returned in the result set. You can instruct the ServiceNow API to send only specific columns by setting the Fields parameter in the WITH clause. This significantly speeds up the response.

SELECT number,name FROM incident WITH (Fields='number,name') --Setting Fields parameter will speed up the query