I wrote sql query. When I run it in SQL Developer or SLQ/Plus it runns fast. When I runn it in Crystal it takes two minutes!. I even created a materialized view and added indexes. I realdy to pull my hair out and ideas?

check the option for "Use Indexes Or Server for Speed".
it is under menu "File-Report Options" in Crystal Reports.

hope it helps (and not late to reply ).

emir