I have created a VDS with reflection.
while running a select on VDS its scanning all the available reflections and then using the suitable reflection for accelerating the query.
This scanning is causing the slowness to query as there are many reflections is available is system.
Can you please suggest a way where we can point to a single reflection and avoid scanning all the reflections?
Thanks in advance