Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Matt Penning — — source: Usenet: comp.databases.informix
Hi all,
I'm having performance problems with views in IDS 10 (RC3,Linux).
Creating a simple view with one join and then querying against it
results in not only a temporary table being created, but a temporary
table with no indexes on it. The temp table creation followed by
sequential scan is obviously very expensive.
Is there anyway to provide hints in the view query or anything else that
can be done to make a view more performant?
This is the test I did with the stores_demo database, and the results:
Test
--------------------------
set explain on;
create view vw_orderfname as
select order_num, fname from orders
left join customer on orders.customer_num=customer.customer_num;select * from vw_orderfname where order_num=1008;
Results
--------------------------
Estimated Cost: 19
Estimated # of Rows Returned: 1
1) (Temp Table For View): SEQUENTIAL SCAN
- Matt
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.