结合项目实践板块总体发帖内容，从如下几个角度进行了整理和汇总，方便大家查阅与检索。
后续如有精品将持续进行更新~
分类整理如下：
| 序号 | 主题分类 | 应用场景 | 标题 | 访问链接 |
| 1 | 迁移系列 | oracle语法迁移 | 【oracle语法迁移】存储过程中table%rowtype语法改写 | https://bbs.huaweicloud.com/forum/thread-132423-1-1.html |
| 2 | 【oracle语法迁移】pivot语法 | https://bbs.huaweicloud.com/forum/thread-123046-1-1.html | ||
| 3 | 【oracle语法迁移】max/min...keep语法 | https://bbs.huaweicloud.com/forum/thread-123044-1-1.html | ||
| 4 | 【oracle语法迁移】rownum语法迁移案例 | https://bbs.huaweicloud.com/forum/thread-114322-1-1.html | ||
| 5 | 【oracle语法迁移】connect_by_root语法迁移案例 | https://bbs.huaweicloud.com/forum/thread-114317-1-1.html | ||
| 6 | 【oracle语法迁移】order siblings by语法迁移案例 | https://bbs.huaweicloud.com/forum/thread-114312-1-1.html | ||
| 7 | 【oracle语法迁移】sys_connect_by_path语法迁移案例 | https://bbs.huaweicloud.com/forum/thread-114307-1-1.html | ||
| 8 | 【oracle语法迁移】单表递归语法迁移案例 | https://bbs.huaweicloud.com/forum/thread-114304-1-1.html | ||
| 9 | gauss db（dws）迁移系列-oracle 函数转换差异（四） | https://bbs.huaweicloud.com/forum/thread-122099-1-1.html | ||
| 10 | gauss db（dws）迁移系列-oracle 函数转换差异（二） | https://bbs.huaweicloud.com/forum/thread-122098-1-1.html | ||
| 11 | gauss db（dws）迁移系列-oracle 函数转换差异（一） | https://bbs.huaweicloud.com/forum/thread-122097-1-1.html | ||
| 12 | gauss db（dws）迁移系列-oracle 数据类型差异 | https://bbs.huaweicloud.com/forum/thread-122096-1-1.html | ||
| 13 | oracle列转行unpivot函数语法转换 | https://bbs.huaweicloud.com/forum/thread-133591-1-1.html | ||
| 14 | oracle 分析函数 keep改造方案 | https://bbs.huaweicloud.com/forum/thread-122150-1-1.html | ||
| 15 | oralce in相关子查询中包含distinct gauss适配改造 | https://bbs.huaweicloud.com/forum/thread-122146-1-1.html | ||
| 16 | oralce listagg/stragg/wm_concat 迁移改造方案 | https://bbs.huaweicloud.com/forum/thread-122145-1-1.html | ||
| 17 | oracle 递归改造案例 | https://bbs.huaweicloud.com/forum/thread-122143-1-1.html | ||
| 18 | oracle package 在gauss中的替换方法 | https://bbs.huaweicloud.com/forum/thread-122103-1-1.html | ||
| 19 | gauss与oracle存储过程差异和改写方法 | https://bbs.huaweicloud.com/forum/thread-122102-1-1.html | ||
| 20 | gaussdb和oracle ddl的差异和替换示例 | https://bbs.huaweicloud.com/forum/thread-122101-1-1.html | ||
| 21 | gauss 和 oracle dml的差异和规避方案 | https://bbs.huaweicloud.com/forum/thread-122100-1-1.html | ||
| 22 | [项目实践-迁移系列] gauss db（dws）迁移系列-oracle迁移分析函数 | https://bbs.huaweicloud.com/forum/thread-122095-1-1.html | ||
| 23 | oracle 触发器在gaussdb(dws)上的实现 | https://bbs.huaweicloud.com/forum/thread-117970-1-1.html | ||
| 24 | oracle connect_by_root，connect_by_isleaf等在gaussdb(dws)实现 | https://bbs.huaweicloud.com/forum/thread-117964-1-1.html | ||
| 25 | td语法迁移 | 【teradata语法迁移】volatile表语法迁移改写 | https://bbs.huaweicloud.com/forum/thread-117690-1-1.html | |
| 26 | 【teradata语法迁移】teradata set语法迁移案例 | https://bbs.huaweicloud.com/forum/thread-117686-1-1.html | ||
| 27 | gauss db（dws）迁移系列-td迁移ddl差异-分区定义设置partition by | https://bbs.huaweicloud.com/forum/thread-117993-1-1.html | ||
| 28 | gauss db（dws）迁移系列-td迁移ddl差异-字段字符集设置character set latin | https://bbs.huaweicloud.com/forum/thread-117990-1-1.html | ||
| 29 | gauss db（dws）迁移系列-td迁移ddl差异-字段多值压缩属性compress | https://bbs.huaweicloud.com/forum/thread-117989-1-1.html | ||
| 30 | gauss db（dws）迁移系列-td迁移ddl差异-字段数据格式化显式属性format | https://bbs.huaweicloud.com/forum/thread-117988-1-1.html | ||
| 31 | gauss db（dws）迁移系列-td迁移ddl差异-视图迁移差异 | https://bbs.huaweicloud.com/forum/thread-117985-1-1.html | ||
| 32 | gauss db（dws）迁移系列-td迁移ddl差异-大小写敏感casespecific/not casespecific | https://bbs.huaweicloud.com/forum/thread-117982-1-1.html | ||
| 33 | gauss db（dws）迁移系列-td迁移ddl差异-行列存存储格式 | https://bbs.huaweicloud.com/forum/thread-117981-1-1.html | ||
| 34 | gauss db（dws）迁移系列-td迁移ddl差异-是否允许重复记录set/multiset | https://bbs.huaweicloud.com/forum/thread-117955-1-1.html | ||
| 35 | gauss db（dws）迁移系列-td迁移ddl差异-可变临时表volatile | https://bbs.huaweicloud.com/forum/thread-117952-1-1.html | ||
| 36 | gauss db（dws）迁移系列-td的日期类型和数值型互转操作差异 | https://bbs.huaweicloud.com/forum/thread-117946-1-1.html | ||
| 37 | gauss db（dws）迁移系列-teradata迁移pivot/unpivot 语法转换对照 | https://bbs.huaweicloud.com/forum/thread-113049-1-1.html | ||
| 38 | td常用字典视图在gaussdb(dws)上实现 | https://bbs.huaweicloud.com/forum/thread-117977-1-1.html | ||
| 39 | gauss db（dws）迁移系列-td迁移函数之next函数 | https://bbs.huaweicloud.com/forum/thread-114003-1-1.html | ||
| 40 | mysql语法迁移 | 【mysql语法迁移】str_to_date()迁移 | https://bbs.huaweicloud.com/forum/thread-136679-1-1.html | |
| 41 | 【mysql语法迁移】date_format()语法迁移 | https://bbs.huaweicloud.com/forum/thread-136677-1-1.html | ||
| 42 | 【mysql语法迁移】分页查询 | https://bbs.huaweicloud.com/forum/thread-136674-1-1.html | ||
| 43 | 【mysql语法迁移】double类型迁移 | https://bbs.huaweicloud.com/forum/thread-136673-1-1.html | ||
| 44 | 【mysql语法迁移】auto_increment自增列迁移 | https://bbs.huaweicloud.com/forum/thread-136672-1-1.html | ||
| 45 | 【mysql语法迁移】datetime类型 | https://bbs.huaweicloud.com/forum/thread-136671-1-1.html | ||
| 46 | 【mysql语法迁移】表注释迁移 | https://bbs.huaweicloud.com/forum/thread-136669-1-1.html | ||
| 47 | 【mysql语法迁移】列注释迁移 | https://bbs.huaweicloud.com/forum/thread-136668-1-1.html | ||
| 48 | gaussdb(dws)实践系列-mysql->gaussdb(dws)常用语法对照表 | https://bbs.huaweicloud.com/forum/thread-146647-1-1.html | ||
| 49 | adb for mysql 【insert [ignore] into table_name】迁移 dws 改写方法 | https://bbs.huaweicloud.com/forum/thread-111391-1-1.html | ||
| 50 | 对接系列 | etl对接 | gaussdb(dws)与kettle对接指导 | https://bbs.huaweicloud.com/forum/thread-104549-1-1.html |
| 51 | informatica10.2与gaussdb a对接 | https://bbs.huaweicloud.com/forum/thread-119448-1-1.html | ||
| 52 | gaussdb(dws)与ogg对接 | https://bbs.huaweicloud.com/forum/thread-102196-1-1.html | ||
| 53 | 驱动对接 | jdbc 对接 gaussdb（dws）的数据库连接问题 | https://bbs.huaweicloud.com/forum/thread-101725-1-1.html | |
| 54 | dws perl通过odbc连接gaussdb(dws) | https://bbs.huaweicloud.com/forum/thread-119608-1-1.html | ||
| 55 | aix服务器安装psql工具连接gaussdb dws | https://bbs.huaweicloud.com/forum/thread-119444-1-1.html | ||
| 56 | 使用python连接gaussdb（dws） | https://bbs.huaweicloud.com/forum/thread-119609-1-1.html | ||
| 57 | bi报表 | dws使用.net驱动对接powerbi | https://bbs.huaweicloud.com/forum/thread-133293-1-1.html | |
| 58 | dws power bi对接指导 | https://bbs.huaweicloud.com/forum/thread-120839-1-1.html | ||
| 59 | gaussdb(dws)对接obiee指导 | https://bbs.huaweicloud.com/forum/thread-102193-1-1.html | ||
| 60 | cognos11.0.12 对接gaussdb a | https://bbs.huaweicloud.com/forum/thread-119437-1-1.html | ||
| 61 | gauss db（dws）对接系列-bi工具bip对接 | https://bbs.huaweicloud.com/forum/thread-109303-1-1.html | ||
| 62 | 跨源访问 | 使用dws访问存算分离的mrs集群的数据 | https://bbs.huaweicloud.com/forum/thread-117770-1-1.html | |
| 63 | 【融合对接】dws和hadoop互联互通--读取hdfs数据和将数据写入hdfs | https://bbs.huaweicloud.com/forum/thread-113331-1-1.html | ||
| 64 | dws对接dli flink实现实时数据接入 | https://bbs.huaweicloud.com/forum/thread-124688-1-1.html | ||
| 65 | gauss db（dws） dws与obs数据互导 | https://bbs.huaweicloud.com/forum/thread-119433-1-1.html | ||
| 66 | 实践系列 | 性能优化 | 解决表过多导致的 pgxc_get_stat_all_tables 查询慢问题 | https://bbs.huaweicloud.com/forum/thread-101196-1-1.html |
| 67 | dws内存参数调优 | https://bbs.huaweicloud.com/forum/thread-99652-1-1.html | ||
| 68 | gaussdb(dws) 【低效sql分析案例】 | https://bbs.huaweicloud.com/forum/thread-131969-1-1.html | ||
| 69 | gaussdb(dws)实践系列-行级访问策略优化实践 | https://bbs.huaweicloud.com/forum/thread-130766-1-1.html | ||
| 70 | dws 多表关联创建pck提升性能 | https://bbs.huaweicloud.com/forum/thread-119538-1-1.html | ||
| 71 | gaussdb(dws)实践系列-性能优化最佳实践 | https://bbs.huaweicloud.com/forum/thread-118241-1-1.html | ||
| 72 | dws 泰山服务器未做配置加固影响性能的问题 | https://bbs.huaweicloud.com/forum/thread-110780-1-1.html | ||
| 73 | dws 参数设置不合理导致作业下盘影响性能的问题 | https://bbs.huaweicloud.com/forum/thread-110776-1-1.html | ||
| 74 | dws 统计信息不准触发nestloop导致查询语句执行缓慢 | https://bbs.huaweicloud.com/forum/thread-110543-1-1.html | ||
| 75 | dws sql语句中in常量优化 | https://bbs.huaweicloud.com/forum/thread-110535-1-1.html | ||
| 76 | dws 语句中not in触发nestloop导致sql执行慢的问题 | https://bbs.huaweicloud.com/forum/thread-110506-1-1.html | ||
| 77 | dws语句不下推问题分析 | https://bbs.huaweicloud.com/forum/thread-110436-1-1.html | ||
| 78 | gauss 子查询性能调优 | https://bbs.huaweicloud.com/forum/thread-122147-1-1.html | ||
| 79 | gaussdb 中实现current_user下推的方法 | https://bbs.huaweicloud.com/forum/thread-122131-1-1.html | ||
| 80 | 应用技巧 | gaussdb的递归 | https://bbs.huaweicloud.com/forum/thread-101514-1-1.html | |
| 81 | 行转列的一个函数 | https://bbs.huaweicloud.com/forum/thread-100204-1-1.html | ||
| 82 | 通过sql查询获取表字段详细信息 | https://bbs.huaweicloud.com/forum/thread-133428-1-1.html | ||
| 83 | 通过sql查询快速获取分区表的的分区键 | https://bbs.huaweicloud.com/forum/thread-133424-1-1.html | ||
| 84 | 处理执行sql文件时，某个sql语句报错，需要继续执行其余sql，直至所有sql执行完毕。 | https://bbs.huaweicloud.com/forum/thread-132498-1-1.html | ||
| 85 | gaussdb(dws) 【查询包含某个字段的所有表清单方法】 | https://bbs.huaweicloud.com/forum/thread-131778-1-1.html | ||
| 86 | gaussdb(dws) 【多值列场景的处理方法】 | https://bbs.huaweicloud.com/forum/thread-131777-1-1.html | ||
| 87 | gaussdb(dws) 【并发测试脚本】 | https://bbs.huaweicloud.com/forum/thread-131776-1-1.html | ||
| 88 | gaussdb(dws) 【常用对象赋权方法】 | https://bbs.huaweicloud.com/forum/thread-131775-1-1.html | ||
| 89 | gaussdb(dws) 【角色权限相关视图使用方法】 | https://bbs.huaweicloud.com/forum/thread-131774-1-1.html | ||
| 90 | gaussdb(dws) 【查询对象所有权限属性的两种方法】 | https://bbs.huaweicloud.com/forum/thread-131772-1-1.html | ||
| 91 | gaussdb(dws)【用sql方式查询所有带主键的表的主键字段方法】 | https://bbs.huaweicloud.com/forum/thread-131771-1-1.html | ||
| 92 | gaussdb(dws)【通过sql方式查询分区表的的分区字段方法】 | https://bbs.huaweicloud.com/forum/thread-131770-1-1.html | ||
| 93 | gaussdb(dws)【查找视图依赖的表对象方法】 | https://bbs.huaweicloud.com/forum/thread-131377-1-1.html | ||
| 94 | gaussdb(dws)实践系列-低效业务脚本检测指导 | https://bbs.huaweicloud.com/forum/thread-151360-1-1.html | ||
| 95 | gaussdb(dws)实践系列-函数实现json类型解析 | https://bbs.huaweicloud.com/forum/thread-151349-1-1.html | ||
| 96 | gaussdb(dws)实践系列-roaringbitmap替换方案 | https://bbs.huaweicloud.com/forum/thread-151119-1-1.html | ||
| 97 | gaussdb(dws)实践系列-list行转列函数实现 | https://bbs.huaweicloud.com/forum/thread-148308-1-1.html | ||
| 98 | gaussdb(dws)实践系列-分区表ttl管理实现 | https://bbs.huaweicloud.com/forum/thread-147907-1-1.html | ||
| 99 | gaussdb(dws)实践系列-日常硬件巡检指导 | https://bbs.huaweicloud.com/forum/thread-146654-1-1.html | ||
| 100 | 【实践系列】gaussdb(dws)存储过程中实现作业执行过程日志记录方法 | https://bbs.huaweicloud.com/forum/thread-124684-1-1.html | ||
| 101 | gaussdb(dws)倾斜表查询实践 | https://bbs.huaweicloud.com/forum/thread-127754-1-1.html | ||
| 102 | dws 局部聚簇（partial cluster key）选取规则 | https://bbs.huaweicloud.com/forum/thread-112478-1-1.html | ||
| 103 | dws 开发过程中sql编写建议 | https://bbs.huaweicloud.com/forum/thread-112471-1-1.html | ||
| 104 | 数据仓库，数据脱敏、and，or，in处置方案 | https://bbs.huaweicloud.com/forum/thread-99866-1-1.html |
赞~