能帮忙解答下OceanBase数据库分区的问题，运行了几年的项目，数据量快到1亿了，需要考虑使用分区。1、分区之后，汇总分页查询时的排序逻辑，比如一页展示20条数据，如果这20条刚好分布在不同的分区上，展示的时候，是将数据按条件过滤好之后，再排序吗？2、分区之后，如果查询条件不带映射字段，对查询有什么影响？

问答 2023-12-12 来自：开发者社区

请教个OceanBase数据库问题，是因为date_format会导致不能按分区查询数据吗？

请教个OceanBase数据库问题，一级分区是rang 按照data_time时间字段分区，查询数据的时候用date_format了data_time 导致扫描了所有的一级分区。是因为date_format会导致不能按分区查询数据吗？不用date_format data_time字段就可以找到指定分区去查询数据

问答 2023-11-29 来自：开发者社区

在OceanBase数据库中，怎么实现按city属性对表A进行分区

请教一下，表A里面没有属性city，表B里有属性city，可以实现按city属性对表A进行分区吗，比如表A和表B可以做一个等值连接，然后按连接后的表A-B的city属性来对表A进行分区

共有56条

< 2 3 4 5 6 >

跳转至： GO

更新时间 2024-08-14 10:05:21

本页面内关键词为智能算法引擎基于机器学习所生成，如有任何问题，可在页面下方点击"联系我们"与我们沟通。

云数据库OceanBase更多数据库相关

云数据库OceanBase您可能感兴趣

产品推荐

{"optioninfo":{"dynamic":"ture","static":"true"},"simplifiedDisplay":"newEdition","newCard":[{"ifIcon":"img","link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","icon":"","iconImg":"https://img.alicdn.com/tfs/TB1otUZn6MZ7e4jSZFOXXX7epXa-200-200.png","contentLink":"https://www.aliyun.com/product/oceanbase","title":"云数据库 OceanBase 版","des":"OceanBase 是阿里巴巴和蚂蚁金服完全自主研发的金融级分布式关系数据库，在普通硬件上实现金融级高可用，在金融行业首创“三地五中心”城市级故障自动无损容灾新标准，同时具备在线水平扩展能力。","link1":"https://www.aliyun.com/product/oceanbase","btn1":"免费试用","link2":"https://oceanbasenext.console.aliyun.com/?spm=5176.cnoceanbase.0.0.725d48d8LQcKBB","btn2":"管理控制台","btn3":"产品文档","link3":"https://help.aliyun.com/product/26458.html","infoGroup":[{"infoName":"产品入门","infoContent":{"firstContentName":"快速入门","lastContentName":"常见问题","firstContentLink":"https://help.aliyun.com/document_detail/139264.html?spm=a2c4g.11174283.6.549.24a92f01ZlGhty","lastContentLink":"https://help.aliyun.com/document_detail/157423.html?spm=a2c4g.11174283.6.925.24a92f01ZlGhty"}},{"infoName":"开源社区","infoContent":{"firstContentLink":"https://www.oceanbase.com/product/opensource","firstContentName":"OceanBase开源社区版","lastContentLink":"","lastContentName":""}},{"infoName":"解决方案","infoContent":{"firstContentLink":"https://www.oceanbase.com/solution/home?type=industry","firstContentName":"场景及行业解决方案集"}},{"infoContent":{"firstContentLink":"https://www.oceanbase.com/customer/home","firstContentName":"与400+企业共同成长"},"infoName":"客户案例"}]}],"card":[],"search":[],"infoCard":[],"title":{"mainTitle":"mPaaS","subtitle":"源自于支付宝小程序框架，亿级线上业务体量的锤炼，安全性媲美支付宝原生能力。不仅面向自有 App 投放小程序，更可快速构建打包，覆盖支付宝、淘宝、钉钉等应用。","linkUrl":"https://www.aliyun.com/product/mobilepaas/mpaas-miniprogram","btnText":"查看详情"},"visual":{"topbg":"https://img.alicdn.com/tfs/TB1bQuBIYH1gK0jSZFwXXc7aXXa-3840-740.gif","icon":"","textColor":"dark"},"dataList":[],"sceneCard":[],"txt":[]}

{"$env":{"JSON":{}},"$page":{"env":"production"},"$context":{"optioninfo":{"dynamic":"ture","static":"true"},"simplifiedDisplay":"newEdition","newCard":[{"ifIcon":"img","link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","icon":"","iconImg":"https://img.alicdn.com/tfs/TB1otUZn6MZ7e4jSZFOXXX7epXa-200-200.png","contentLink":"https://www.aliyun.com/product/oceanbase","title":"云数据库 OceanBase 版","des":"OceanBase 是阿里巴巴和蚂蚁金服完全自主研发的金融级分布式关系数据库，在普通硬件上实现金融级高可用，在金融行业首创“三地五中心”城市级故障自动无损容灾新标准，同时具备在线水平扩展能力。","link1":"https://www.aliyun.com/product/oceanbase","btn1":"免费试用","link2":"https://oceanbasenext.console.aliyun.com/?spm=5176.cnoceanbase.0.0.725d48d8LQcKBB","btn2":"管理控制台","btn3":"产品文档","link3":"https://help.aliyun.com/product/26458.html","infoGroup":[{"infoName":"产品入门","infoContent":{"firstContentName":"快速入门","lastContentName":"常见问题","firstContentLink":"https://help.aliyun.com/document_detail/139264.html?spm=a2c4g.11174283.6.549.24a92f01ZlGhty","lastContentLink":"https://help.aliyun.com/document_detail/157423.html?spm=a2c4g.11174283.6.925.24a92f01ZlGhty"}},{"infoName":"开源社区","infoContent":{"firstContentLink":"https://www.oceanbase.com/product/opensource","firstContentName":"OceanBase开源社区版","lastContentLink":"","lastContentName":""}},{"infoName":"解决方案","infoContent":{"firstContentLink":"https://www.oceanbase.com/solution/home?type=industry","firstContentName":"场景及行业解决方案集"}},{"infoContent":{"firstContentLink":"https://www.oceanbase.com/customer/home","firstContentName":"与400+企业共同成长"},"infoName":"客户案例"}]}],"card":[],"search":[],"infoCard":[],"title":{"mainTitle":"mPaaS","subtitle":"源自于支付宝小程序框架，亿级线上业务体量的锤炼，安全性媲美支付宝原生能力。不仅面向自有 App 投放小程序，更可快速构建打包，覆盖支付宝、淘宝、钉钉等应用。","linkUrl":"https://www.aliyun.com/product/mobilepaas/mpaas-miniprogram","btnText":"查看详情"},"visual":{"topbg":"https://img.alicdn.com/tfs/TB1bQuBIYH1gK0jSZFwXXc7aXXa-3840-740.gif","icon":"","textColor":"dark"},"dataList":[],"sceneCard":[],"txt":[]}}