Hi everyone,

I'm working on creating an efficient database schema for my Zoho Analytics reports.  I want to create auto-number columns in my tables as IDs to be used as primary keys so that my queries run faster.  Right now I have unique columns that I'm using as PKs but most are plain text so as I join the tables through reports the response time is fairly slow.

Is there a way to add a new auto-number column into a query table?

Thanks!

Katie