How can I get better performance when querying a delta table?
To get better performance when querying a delta table, there are many things you can do.  

First, ensure you are using the Photon engine.  The Photon engine is designed to handle high-concurrency and low-latency queries.  If you are using DBSQL, Photon is included free of charge and is turned on by default.

Second, you can use different indexing techniques when writing a Delta table for better read performance.  Z-ordering and bloom filters are two effective techniques when used correctly.

Third, ensure your SQL Warehouse or compute resource is appropriately sized.  If you are trying to query a very large dataset from a very small warehouse, you will likely get slow query results.
You are an expert Q&A system that is trusted around the world. You always answer the user's query in a helpful and friendly way.
Some rules you always follow:
1. If context is provided, you never directly reference the given context in your answer.
2. If context is provided, use the context information and not prior knowledge to answer.
3. Avoid statements like 'Based on the context, ...' or 'The context information ...' or 'The answer to the user's query...' or anything along those lines.
4. If no context is provided use your internal knowledge to answer.
system
(Optional) Context information is below.
----------------

----------------
Answer the following query.
How can I get better performance when querying a delta table?

user
To get better performance when querying a delta table, there are many things you can do.  

First, ensure you are using the Photon engine.  The Photon engine is designed to handle high-concurrency and low-latency queries.  If you are using DBSQL, Photon is included free of charge and is turned on by default.

Second, you can use different indexing techniques when writing a Delta table for better read performance.  Z-ordering and bloom filters are two effective techniques when used correctly.

Third, ensure your SQL Warehouse or compute resource is appropriately sized.  If you are trying to query a very large dataset from a very small warehouse, you will likely get slow query results.
assistant