Create the effective index

[pappatch]

Hi

I want to create the best index for thar query:

"select * from talkback where status=0 order by bject_type,vertical_id,event_id"

Which index i need to create for best performance.

10X

[Aggro]

pappatch wrote:

I want to create the best index for thar query:

"select * from talkback where status=0 order by bject_type,vertical_id,event_id"

Which index i need to create for best performance.

Atleast status should be indexed.

I'm not sure if you get any increase to performance if you also index
the order by fields, but if you like to you can test whether it helps or
not:

index( status, bject_type,vertical_id,event_id )

[Aggro]

pappatch wrote:

I want to create the best index for thar query:

"select * from talkback where status=0 order by bject_type,vertical_id,event_id"

Which index i need to create for best performance.

Atleast status should be indexed.

I'm not sure if you get any increase to performance if you also index
the order by fields, but if you like to you can test whether it helps or
not:

index( status, bject_type,vertical_id,event_id )