Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 10
Newest
 Cleanup
Impact
~4k people reached

  • 0 posts edited
  • 0 helpful flags
  • 8 votes cast
Sep
25
awarded  Cleanup
Sep
25
awarded  Custodian
Sep
25
revised How are multiple indexes used in a query by MySQL?
edited body
Sep
25
revised How are multiple indexes used in a query by MySQL?
rolled back to a previous revision
Sep
25
reviewed Approve How are multiple indexes used in a query by MySQL?
Sep
15
awarded  Notable Question
Aug
4
awarded  Caucus
Sep
24
awarded  Autobiographer
Apr
1
awarded  Popular Question
Sep
18
awarded  Commentator
Sep
18
comment How are multiple indexes used in a query by MySQL?
Thanks. One question, cardinality of column is important in deciding whether to apply index on a column. Can you please explain why? And why would cardinality play a role in deciding the ordering of the columns here? If you can update your answer with a detailed explanation, I would be really grateful.
Sep
18
accepted How are multiple indexes used in a query by MySQL?
Sep
18
asked How are multiple indexes used in a query by MySQL?
Sep
14
accepted Aren't two writes required to update a clustered index record
Sep
13
comment Aren't two writes required to update a clustered index record
Ummm, what is meant by that?
Sep
13
comment Aren't two writes required to update a clustered index record
I didn't quite understand your last statement. If you look at the ppt at google.co.in/… , you will find that when 5 is inserted, the 8 in the leaf level is pushed to the non-leaf level, effectively creating two copies of it.
Sep
13
comment Aren't two writes required to update a clustered index record
No, even there it says the that there are two different writes, not modification of object in two places.
Sep
13
comment Aren't two writes required to update a clustered index record
@AlexKuznetsov Have a look at the article at technet.microsoft.com/library/Cc917672 under the section Test 1: INSERT Performance.
Sep
13
awarded  Editor
Sep
13
revised Aren't two writes required to update a clustered index record
added 815 characters in body