Hi Agnes
>I use "view" to create serveral tables.
>However, How can I set the index key ?? As i need to use "SEEK" in my program ?
You cannot define a persistent index on a view. However, you can create an index on a view yourself because views are always local to the user and are opened exclusive.
SELECT [view]
CURSORSETPROP('buffering', 3 )
INDEX ON [expression] TAG [name]
>
>More, as I use create view, there is an option to choose [no of records] or [percent] .
>Will this option affect the performance of the view ???
The short answer is 'it depends'. There will be some impact because you are forcing some addditional processing, but whether you would ever notice it is another question. If you need either of those functions, use them.
----
Regards
Andy Kramek