pfzhan opened a new pull request, #2195: URL: https://github.com/apache/kylin/pull/2195
**SQL-Based Model and Index Creation** 1. **Quick Model Creation:** Upload SQL files directly through the front-end interface to rapidly create models and generate corresponding indexes. 2. **Index Optimization Recommendations:** Leverage existing models to recommend and optimize indexes, improving query performance. 3. **Historical Query Analysis:** Generate index optimization suggestions based on query history. Select the most profitable recommendations through statistical analysis, which users can review and approve via the front-end interface. 4. **Unnecessary Index Elimination:** Use statistical insights to identify and recommend the removal of redundant indexes. 5. **Enhanced Left Join Models:** For left join models, add new dimension tables by configuring `kylin.smart.conf.model-opt-rule=append`. 6. **Optimized Aggregation Indexes:** For excluded columns, configure `kylin.smart.conf.propose-all-foreign-keys=false` to maximize the aggregation of recommended indexes. 7. **Further Configuration:** For additional recommended settings, refer to the full range of SmartConfig configurations and specific settings within the `KylinConfigBase` class. --------- Co-authored-by: Yifei.Wu <[email protected]> Co-authored-by: Yifan Zhang <[email protected]> Co-authored-by: Zhiting Guo <[email protected]> Co-authored-by: huangfeng1993 <[email protected]> Co-authored-by: Junqing Cai <[email protected]> Co-authored-by: Jiale He <[email protected]> Co-authored-by: Liang.Hua <[email protected]> Co-authored-by: lixiang <[email protected]> Co-authored-by: Ruixuan Zhang <[email protected]> Co-authored-by: lionelcao <[email protected]> Co-authored-by: Cheng Hao <[email protected]> Co-authored-by: xinbei <[email protected]> Co-authored-by: bingfeng.guo <[email protected]> Co-authored-by: lxian2shell <[email protected]> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
