slowness in trying to perform filter / Search in SN sow

[chercm]

i am trying to perform search and filer in SOW but not sure why it is very slow. 

Trying to filter out tickets for 3 assignment for the past 30 days and with the short description contains slow , performance and BSOD and it is hanging. we have 3 different region in testing and they are ok but in prod it does not work and it is very very slow 

[Sateesh Kumar D]

Out of the 3 fields you are querying on , assignment group / assigned to , created on and short description, the field short description is usually not indexed (and is not advisable to index such length string field too) and so the query could be performing slow . Usually in non prod there may not be such huge data and so you wouldn't have observed the slowness whereas in prod there could be larger data which slows down the query.