Table design and index/primary key problem
Posted: Thu Apr 15, 2004 7:26 pm
Hello,
i have the followed table:
i made an additional column id, because a primary key should not/never change.
it depend on whitch mode the session management is running, whitch columns are changing...
the worst scenario is like described above..
it doesn't make sens to make an index over sess1,sess2,sess3,sess4 because they change very often, does it?
shouldn't i have an index over some columns, should i?
can someone help me or give me an advice for this problem?
greez Pozor
i have the followed table:
Code: Select all
id int 11 unsigned auto_increment Primary Key changes never
sess1 varchar 32 changes very often
sess2 varchar 32 changes very often
sess3 varchar 32 changes very often
sess4 varchar 32 changes very often
userid int 11 unsigned changes rearely/never
secure tinyint 1 unsigned changes rearely
variables text changes sometime
timestamp timestamp 14 changes very oftenit depend on whitch mode the session management is running, whitch columns are changing...
the worst scenario is like described above..
it doesn't make sens to make an index over sess1,sess2,sess3,sess4 because they change very often, does it?
shouldn't i have an index over some columns, should i?
can someone help me or give me an advice for this problem?
greez Pozor