1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Your table has a large character field there are queries that use this field in their search clause what should you do?

Question Posted / sandeeep kumar


Your table has a large character field there are queries that use this field in their search clause ..

Answer / Lalit Tyagi

To improve performance when dealing with large character fields, consider using full-text indexing. You can also split the data into smaller chunks and store them separately to reduce the size of individual rows.nnAdditionally, you might want to use filtered indexes or compute column statistics if you frequently search for specific values within the character field.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How are the unique and primary key constraints different?

1 Answers  

Explain syntax for viewing trigger?

1 Answers  

How to convert numeric values to integers in ms sql server?

1 Answers  

What is difference between equi join and inner join?

1 Answers  

What is the difference between a primary key and a unique key? Are they the same?

1 Answers  

Explain system scalar functions?

1 Answers  

What are the different types of replication? How are they used?

3 Answers  

How do I start sql server 2016?

1 Answers  

can any body tell me how to know the password of current user in sql server

1 Answers   Crea, HCL,

How to find the list of fixed hard drive and free space on server?

1 Answers  

Determine how to use the inserted and deleted pseudo tables?

1 Answers  

How do I open a .db file?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories