|
-
Creating Views and indexing views
Hi,
I am trying to create a view of a large table (1,000,000 rows) which has keys. However, when I run 'help viewname' the output indicates that the resulting view does not contain index/key information. As I intend to use the view rather than the base table to execute queries, I was wondering if the lack of key info will have a detremental effect on the query exectuion time.
Thanks,
Paul
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|