Re: views

mwest_at_hort.cri.nz wrote:
>
> Is it possible to have indexes on views. I am trying to use a oracle view
> and a table in paradox but cannot join them unless they are both indexed.
> Any ideas??

Create your indexes on the base tables that form the view. Views are logical ways of looking at data and in my experience are primarily used to create derived columns or just to make it easier for users to get at data. Create indexes on the join condition columns and also talk with users who will be using the views (or developers who will be using them in code) and find out what their where clauses will be and create indexes on those as well.

Hope this helps

-- 
===========================================================
|Bill Schoonmaker	Oracle DBA	Broadway & Seymour|
|                bill.schoonmaker_at_bsis.com                |
|    These opinions are mine only - not my employer's     |
===========================================================