SELECT * from table_name where TTOC(indexed_field,1) = “200510” ORDER by 1The problem is that I cannot achieve the similar performance in Vb.NET where I use the code below to fill the data adapter:
Me.OleDbSelectCommand2.CommandText = _ "SELECT * FROM table_name WHERE (TTOC(indexed_field,1) = '200510’) ORDER by 1" Me.OleDbDataAdapter2.SelectCommand = Me.OleDbSelectCommand2 Me.OleDbDataAdapter2.Fill(Me.DataSet21)It takes 1 - 2 minute to get the result. Am I missing anything here, or do I need to make specific settings somewhere?