Den 05.02.2016 13.22, skrev kosurusekhar:
> Hi All,
>
> We are having three schemas with almost same table structure, indexes,
> queries, stored procedures in one database. But in one schema we are facing
> some performance issue. We are having same index names and table names in
> all schemas.
Hi All,
We are having three schemas with almost same table structure, indexes,
queries, stored procedures in one database. But in one schema we are facing
some performance issue. We are having same index names and table names in
all schemas. In another schemas it is running without any problem.
You should run your queries and take a look at the query plans being used. It
may be possible that your indexes are not being used as you think. See
http://db.apache.org/derby/docs/10.10/tuning/index.html
the section on "How you use the RUNTIMESTATISTICS attribute”
Possibly the statistics
