Re: Wird Abfrage durch view-Tabellen gebremst?
Hallo Thomas,
mein Fremdschlüssel ist auch gleichzeitig ein Primärschlüssel:
create table personen
(
personen_id int unsigned not null auto_increment primary key,
name varchar(25) not null,
standort_id smallint unsigned not null references standort(standort_id)
) engine = InnoDB;
create table projekte
(
projekt_id smallint unsigned not null auto_increment primary key,
projekt_name varchar(25) not null
) engine = InnoDB;
create table personen_projekte
(
personen_id int unsigned not null references personen(personen_id),
projekt_id smallint unsigned not null references projekte(projekt_id),
primary key(personen_id, projekt_id)
) engine = InnoDB;
Sollte da nicht ohnehin ein Index drauf sein?
Edited 2 time(s). Last edit at 06/01/2011 10:55AM by Alwin Bekker.
Subject
Views
Written By
Posted
3693
May 28, 2011 08:45AM
2100
May 28, 2011 09:57AM
1288
May 28, 2011 10:34AM
1473
May 28, 2011 11:13AM
1245
May 28, 2011 12:01PM
1347
May 28, 2011 12:41PM
1150
May 28, 2011 04:19PM
1453
May 29, 2011 03:42AM
Re: Wird Abfrage durch view-Tabellen gebremst?
1322
June 01, 2011 10:52AM
1344
June 01, 2011 11:11AM
1372
June 02, 2011 08:04AM
1091
May 28, 2011 11:12AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.