---
title: "distinct性能问题一"
author: "winzenghua"
date: "2007-09-30T16:48:00Z"
tags: []
slug: "distinct"
draft: false
lastmod: "2007-09-30T16:48:00Z"
id: 987920
url: "https://java4gis.iteye.com/blog/987920"
---

select distinct username from largetable;  
如果username 可选择性比较低 只有建立位图索引来提高