Re: Unknown error when runing stored procedure

[Ike Walker]

Hi Adrian,

I don't know why you are getting that error. Can you provide specific examples?

As for your second question, INFORMATION_SCHEMA is a virtual database. Its tables are really views, so you can't add indexes to those tables.

One thing you could do if your schema doesn't change much, or if you don't mind using slightly stale data, is to create a copy of the INFORMATION_SCHEMA database and add indexes to your copy.

-- Creating a cached copy of INFORMATION_SCHEMA:

create database INFORMATION_SCHEMA_CACHED;
create table INFORMATION_SCHEMA_CACHED.TABLES as select * from INFORMATION_SCHEMA.TABLES;
alter table INFORMATION_SCHEMA_CACHED.TABLES add key TABLE_NAME (TABLE_NAME);
...

-- Updating the cached copy if your schema changes:

replace into INFORMATION_SCHEMA_CACHED.TABLES select * from INFORMATION_SCHEMA.TABLES;
...