My query goes like this:

Select a.Name, a.Id From Account a WHERE OwnerId = 'xyz'

This query times out when queried against salesfoce database with huge number of accounts (looks like they have millions of records) Can someone provide me with options I have in this scenario?

Thanks

My query goes like this:

Select a.Name, a.Id From Account a WHERE OwnerId = 'xyz' AND (Name LIKE '0%' OR Name LIKE '1%' OR Name LIKE '2%' OR Name like '3%' ) order by Name asc

This query works well in my developer edition environment, but in enterprise environment it doesnt work (I cannot get any results). Can someone please point me in the right direction?

My query goes like this:

Select a.Name, a.Id From Account a WHERE OwnerId = 'xyz'

This query times out when queried against salesfoce database with huge number of accounts (looks like they have millions of records) Can someone provide me with options I have in this scenario?

Thanks

My query goes like this:

Select a.Name, a.Id From Account a WHERE OwnerId = 'xyz' AND (Name LIKE '0%' OR Name LIKE '1%' OR Name LIKE '2%' OR Name like '3%' ) order by Name asc

This query works well in my developer edition environment, but in enterprise environment it doesnt work (I cannot get any results). Can someone please point me in the right direction?