I don't know nothing about virtual index. For SQL Server, an index is a physical file!
>How about if I am not create the index on the table but I create some kinds like virtual index when it was needed, for example:
>
>rsExample!StockCode.properties("Optimize")=true
>
>I need your advise and or suggestion..
>
>TIA
>
>Teddy
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com