為了避免全表掃描, 應該這樣寫:
Sql代碼

1. select spu_id??
2. ??from tbcat2.spu??
3. where category_id = #value#??
4. ???and (status = 0 or status is null)??
5. ???and rownum < 2??

select spu_id from tbcat2.spu where category_id = #value# and (status = 0 or status is null) and rownum < 2

而不是實用count(*)函數, 對于海量數據全表掃描性能是極差的

oracle中判斷記錄是否存在