var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
What is this query implies ?
CREATE view view_test AS SELECT * from test_table alias1 (INDEX = pk_constraint)
Here pk_constraint is the primary key constraint name defined in the table 'test_table'.
Here, what is the effect of (INDEX = pk_constraint)
it's an optimizer hint that forces the optimizer to use it while generating an execution plan for the query. it's not recommended to be used unless you have a full understanding of all implications of a forced plan.
Thanx for your reply.
what it does, if I remove INDEX = pk_constraint and what is the effect of its existence, please explain it clearly
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors