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??A view is a stored SQL stmt that executes when you issue a select stmt
against the view, therefore it does not make sense to create indexes on a view. You can certainly create indexes on columns in the base tables of the view.

-- 
Ashok Kapur (akapur_at_thomtech.com)
Thomson Technology Consulting Group
1375 Piccard Drive, Suite 250
Rockville, MD 20850