I am trying to optimize our database by applying indices. When I apply an index in Interactive SQL, I assume (and it seems) it get's immediately active, i. e. it is immediately in effect? To see the effect/result of the applied index, I run our application. It would be very helpful if I would get some confirmation on my assumption that an index is immediately valid.
– SQL Anywhere 12.0.1, OS X 10.10.5, Java 8
Best regards, Robert
asked 15 Sep '15, 06:03