Indexes of the usr_preferences table

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Indexes of the usr_preferences table

Binan83
Hello, - The user is uniqely identified by UUID or (username , domain) - The user in a specific domain has some preferences formed in (attribute, value) pairs. - Another user (different user or different domain) can have the same references (all or some pairs). The question: is it right to make the "value" as index (value_idx) for "usr_preferences" table ???. If yes why? usr_preferences table scheme
voipmagazine.wordpress.com/