> The view querying another view will have no optimization unless you have > created the index tags on > the view cursor for all join keys. You can verify this by using SYS(3054). > > You can create the index tags on the view after you open it (NODATA or not), > or after the requery is > complete (test to see what is faster). The resulting CDX will disappear when > you close the cursor, > so you have to create the index tags each time.
Hi Rick I thought he meant to speed up the first view. Indexing it would only speed up a second view. Mike Yearwood _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
