I have created the composite primary key which is created successfully but i am not getting the index against the primary key.
When i created a select query and includes the primary key column it is going with full table scan. Even i am creating an index on the columns it is also going with full table scan.
This isn’t a bug, it did create the indexes. The fact that a particular query choose not to use them is not evidence to the contrary.
