Abstract: The query optimization plays important roles in distributed database system.After analyzing algorithm which based on semi-join query,and combining the character of distribute database that there are lots of duplicate queries.It is put forward a kind of semi-join algorithm based on duplicate query.Using a small intermediate result set to reduce the time of calculation and transmission,improved the efficiency of query.