Hello Everyone,
 
I was creating diffrent tables in database by taking year and date from the users with the help of '?' character but the problem is

Does the optimizer treat a query differently when the object names in the query are fully qualified vs. when they are not fully qualified ?
I came across a query which gives one explain plan when the views referenced by the query are fully qualified i.e. <databasename>.<viewname>