# StarRocks Documentation — Using_starrocks > Section index of the StarRocks documentation. For the complete documentation index, see [llms.txt](https://docs.starrocks.io/llms.txt). Pages are available as Markdown at their `.md` URLs. ## Using_starrocks - [Query Acceleration](https://docs.starrocks.io/docs/using_starrocks.md) - [Accelerate Cardinality-Preserving Joins](https://docs.starrocks.io/docs/using_starrocks/accelerate-cardinality-preserving-joins.md): How to use table pruning to accelerate cardinality-preserving joins in StarRocks by removing redundant joined tables that do not affect query results. - [Asynchronous materialized views](https://docs.starrocks.io/docs/using_starrocks/async_mv.md) - [Feature Support: Asynchronous Materialized Views](https://docs.starrocks.io/docs/using_starrocks/async_mv/feature-support-asynchronous-materialized-views.md): Reference for feature support boundaries of asynchronous materialized views in StarRocks: supported join types, aggregate functions, query rewrite... - [Asynchronous materialized views](https://docs.starrocks.io/docs/using_starrocks/async_mv/Materialized_view.md): How to create, use, refresh, and manage asynchronous materialized views in StarRocks for accelerating multi-table join and aggregation queries with... - [Understand Materialized View Task Runs](https://docs.starrocks.io/docs/using_starrocks/async_mv/materialized_view_task_run_details.md): How to view and interpret materialized view refresh task run details in StarRocks to understand refresh behavior, troubleshoot failures, and monitor refresh... - [Asynchronous Materialized View References](https://docs.starrocks.io/docs/using_starrocks/async_mv/mv_ref.md): Reference index for asynchronous materialized view SQL statements (CREATE, ALTER, REFRESH, DROP) and system views for monitoring in StarRocks. - [Troubleshooting asynchronous materialized views](https://docs.starrocks.io/docs/using_starrocks/async_mv/troubleshooting_asynchronous_materialized_views.md): Troubleshooting guide for asynchronous materialized views in StarRocks: how to diagnose and fix refresh failures, query rewrite issues, and data consistency... - [Use cases](https://docs.starrocks.io/docs/using_starrocks/async_mv/use_cases.md) - [Create a partitioned materialized view](https://docs.starrocks.io/docs/using_starrocks/async_mv/use_cases/create_partitioned_materialized_view.md): How to create a partitioned materialized view in StarRocks with time-range or list partitioning for incremental refresh and partition-level query rewrite. - [Data lake query acceleration with materialized views](https://docs.starrocks.io/docs/using_starrocks/async_mv/use_cases/data_lake_query_acceleration_with_materialized_views.md): How to use asynchronous materialized views in StarRocks to accelerate queries against data lake tables (Iceberg, Hive, Hudi, Delta Lake) through transparent... - [Data modeling with materialized views](https://docs.starrocks.io/docs/using_starrocks/async_mv/use_cases/data_modeling_with_materialized_views.md): How to use asynchronous materialized views in StarRocks to simplify ETL pipelines, build reusable data models, and improve query performance through layered... - [Query rewrite with materialized views](https://docs.starrocks.io/docs/using_starrocks/async_mv/use_cases/query_rewrite_with_materialized_views.md): How StarRocks automatically rewrites queries to use asynchronous materialized views for transparent query acceleration, including supported rewrite... - [Caching](https://docs.starrocks.io/docs/using_starrocks/caching.md) - [Data Cache](https://docs.starrocks.io/docs/using_starrocks/caching/block_cache.md): How to configure and use Data Cache in StarRocks to cache data blocks from remote storage (object storage, HDFS) on local disk, accelerating queries in... - [Query Cache](https://docs.starrocks.io/docs/using_starrocks/caching/query_cache.md): How to configure and use Query Cache in StarRocks to store intermediate aggregation results in memory, improving QPS and reducing latency for... - [Colocate Join](https://docs.starrocks.io/docs/using_starrocks/Colocate_join.md): How to use Colocate Join in StarRocks to perform joins locally without network data transmission by co-locating data from joined tables in the same... - [Gather statistics for CBO](https://docs.starrocks.io/docs/using_starrocks/Cost_based_optimizer.md): How to configure StarRocks' cost-based optimizer (CBO) by collecting full, sampled, and histogram statistics for internal and external tables to improve... - [Computing distinct value count](https://docs.starrocks.io/docs/using_starrocks/distinct_values.md) - [Bitmap for Count Distinct](https://docs.starrocks.io/docs/using_starrocks/distinct_values/Using_bitmap.md): How to use bitmaps in StarRocks for efficient COUNT(DISTINCT) calculations using the BITMAP type and bitmap functions, reducing storage space and... - [Use HLL for approximate count distinct](https://docs.starrocks.io/docs/using_starrocks/distinct_values/Using_HLL.md): How to use HyperLogLog (HLL) in StarRocks for approximate COUNT(DISTINCT) with ~1-10% error rate, significantly reducing memory usage for large-scale... - [Flat JSON](https://docs.starrocks.io/docs/using_starrocks/Flat_json.md): How to use Flat JSON in StarRocks to accelerate JSON queries by extracting common fields from JSON columns into flat columnar storage, reducing parsing... - [JIT Compilation for Expressions](https://docs.starrocks.io/docs/using_starrocks/jit.md): How to enable and configure JIT (just-in-time) compilation for expressions in StarRocks to accelerate expression evaluation in query execution. - [Use Lateral Join for column-to-row conversion](https://docs.starrocks.io/docs/using_starrocks/Lateral_join.md): How to use Lateral Join with unnest() in StarRocks to convert array columns to rows (explode), commonly used in ETL pipelines for column-to-row transformation. - [Synchronous materialized view](https://docs.starrocks.io/docs/using_starrocks/Materialized_view-single_table.md): How to create, use, and manage synchronous materialized views (Rollups) in StarRocks for transparent acceleration of single-table aggregate queries with... - [Accelerate COUNT(DISTINCT) and Joins with AUTO INCREMENT and Global Dictionary](https://docs.starrocks.io/docs/using_starrocks/query_acceleration_with_auto_increment.md): How to use AUTO INCREMENT columns and Global Dictionary in StarRocks to replace string keys with integer IDs, accelerating COUNT(DISTINCT) and join operations. - [Query Feedback](https://docs.starrocks.io/docs/using_starrocks/query_feedback.md): How to use Query Feedback in StarRocks to automatically analyze slow query plans, generate optimization guides via Query Plan Advisor, and improve... - [View Running Queries](https://docs.starrocks.io/docs/using_starrocks/running_queries.md): How to view and monitor running queries in StarRocks using current_queries and related views, analyze their resource consumption, and cancel long-running... - [Skew Join V2](https://docs.starrocks.io/docs/using_starrocks/skew_join_v2.md): How to use Skew Join V2 in StarRocks to optimize JOIN queries with data skew by broadcasting skew values, improving performance for heavily skewed data... - [Sorted streaming aggregate](https://docs.starrocks.io/docs/using_starrocks/sorted_aggregate.md): How to use sorted streaming aggregate in StarRocks (available from v2.5) to optimize GROUP BY queries on pre-sorted data, reducing memory overhead compared... - [SQL Plan Manager](https://docs.starrocks.io/docs/using_starrocks/SQL_plan_manager.md): How to use SQL Plan Manager in StarRocks to bind a fixed query plan to a SQL statement, preventing plan changes from statistics or data updates and...