create index on a view

[adhhealth]

pervasive sql 8
I have created a view from a table in another database. I want to create an index on one of the fields. How can I do that?

 

[mirtheil]

You don't create indexes on the view. You create the index on the base table using the CREATE INDEX statement.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[adhhealth]

the issue i have is, i donot have permission to create index on the original table in the database,
i have to create an index on a field in this table for a purpose (reporting)
how can i export this table to another database and create an index on this field?

 

[mirtheil]

You can't create an index on the view because a view is just a stored statement. Have the administrator of the database (or someone with rights) create the index.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[adhhealth]

actually no one has permission to create index on this table, as this database is a backend for a software program and tampering with the indexes might lead to major issues.. hence, i want to know if i can export this table into another database and create an index on the field..

 

[adhhealth]

is there is a possibility to export this table into another database and refresh the table periodically.. so that i can create indexes on this exported table and use it as i want?

 

[mirtheil]

Not automatically. You might be able to use one of the Pervasive Integration products.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[adhhealth]

can you give me more information on this ?

 

[mirtheil]

Check out http://www.pervasive.com/products/index_integration.asp

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com