>Hello
>
>I have a tableA with 4 indexes, when i create a view,how to bring the index also to it.
You can't. However, you can index a view as long as you set buffering to ROW. After you create the indexes, you can set the buffering to whatever you want. Because view indexes can be flaky, I recommend creating the indexes after you populate the view with your data. I also drop the indexes before doing a REQUERY() on a view, then recreate them afterwards. I have had bad luck with the indexes being incorrect in the past unless I handle view indexes this way. This should not be a performance problem because, IMO, views should contain very few records.
Mark McCasland
Midlothian, TX USA