Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>When you use a local updatable view there is no index on the table.
The view creates a cursor. You can index that cursor.
>
>I need to large query on the data and to speed it up I need indexs on the table.
There should be indexes on the table to speed up the query. Indexes on the cursor produced by the view will not improve performance of the query. It may improve performance of subsequent queries of that cursor, but indexing 10 records, just to run a query is not worth it.
I usually only index the cursor to allow seek()/lookup() of a relatively static lookup cursor or to allow reordering of the cursor in a grid etc.
>What is the best way to have index on the Local Updatable view?
>Where do I store the creation of index? (Store Procedure)
I'd put creation of indexes on the cursor in the middle tier.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only