2011-02-09, 01:44
I have also read in various placed in the forum to add these indices as well:
alter table song add index ix_idalbum(idalbum)
create index idartist_idx on song (idartist)
create index idartist_idx on album (idartist)
create index idartist_idx on exartistsong (idartist)
create index idartist_idx on exartistalbum (idartist)
I not yet tried these out myself but intend to tonight.
Can adding too many indices hurt the performance of the database?
alter table song add index ix_idalbum(idalbum)
create index idartist_idx on song (idartist)
create index idartist_idx on album (idartist)
create index idartist_idx on exartistsong (idartist)
create index idartist_idx on exartistalbum (idartist)
I not yet tried these out myself but intend to tonight.
Can adding too many indices hurt the performance of the database?