I Created a view form for the view in the other database using the DBlink. The view form has 12 million records in it. When i try to search in backend (using toad) it works well but it hangs up when i do search in the view form in remedy user tool.

Can anybody help me how to increase the performance. I am also calling this view using a table in other form which shows all the data.

Thanks,
Sat

Any views by anybody

Look at the indexes used by this view and your searches in the another database.

It has indexing performed very well on the other database. But a Scenario is the 'Search field'(Appending 3 other fields into this for searching) is not from the table but its a created field. I am searching the text from this field.

Just want to know whether its doable.Please advise.

Thanks,
Sat

What it the QBE Match option for this field?

When i created a view form the Search_field is Set automatically to Equal in the view form.

Thanks,
Sat

instead of showing all the data in the table, consider using table chunks. i think toad does not show all the data at once either.

Soba,
I am displaying only 100 records in the first chunk of the table, still same result.

sat

Sat,
Remedy should have created a db view for your view form, with spaces and non alphanumeric characters in form name replaced with underscore, like my_form_name. How does it perform when you run the select query on this view, using toad?

I dont have any underyling form, but i have a table. When i search table using toad its fine. Please let me know if any other options and also is it feasible to deal(search) with 12 million records.

Thanks,
Sat

see if you can get the Data owner to Set up some Indexes on the Table that match your most freq. searches.

as you have stated above you are filling in a field on the view that is created from three fileds in the originating table so you are performing a full table search when you access the view it then creates this field entry then you are searching the the field for matches. I hope this helps explain part of your problem.

Thank you Stephen. I have stillthe same problem it just hangs.