470,619 Members | 1,860 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,619 developers. It's quick & easy.

Create the effective index

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
Jul 20 '05 #1
2 1521
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 )
Jul 20 '05 #2
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 )
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by pappatch | last post: by
9 posts views Thread by expect | last post: by
5 posts views Thread by shelleybobelly | last post: by
1 post views Thread by mahesh.kanakaraj | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.